Here’s another FAQ we receive:
I want to have the summary values in my table (or aggregates in groupings) be filtered, but not filter the table itself, what can I do?
To do this, you will want to make use of the
SumIf, MaxIf, etc functions.
This will allow you to in effect apply a Sum function to a filtered subset of a column.
For example:
SumIf( [Sales], [Quantity] > 1 )
Avg, CountDistinct, Count, Max, Min, and Sum all have corresponding …If functions: Aggregate Functions