Dynamic Reports

A dynamic report changes automatically when:

  • Source data changes
  • New records are added
  • A filter/selection changes
  • Values change

Example

=FILTER(A2:H100,D2:D100=K2)

If K2 changes from Sirsa to Hisar, the report automatically changes.

Dynamic Tables

Excel Tables are particularly useful with dynamic formulas because new records can automatically become part of the table.

Example table name:

SalesData

Formula:

=FILTER(SalesData,SalesData[City]=K2)

Advantages

  • Automatically expands
  • Structured references
  • Easier formulas
  • Better compatibility with reports and dashboards

Practice

Convert the sales dataset into a table named:

SalesData

Create a dynamic report based on a selected city.

PreviousNext