Aggregate Calculations in Pivot Table using Rollup

Let’s say you have a pivot table with the rows set as some categorical data column and the columns are the dates, similar to below:

You would like to look for some aggregate metric (max, min, median, etc.) among all the row values for each pivot column value. To do so, you would use the Rollup function to create a static hidden column with the formula or input it directly into where you want to use it for comparison:

Rollup(Median([Profit]), [Quarter of Order Date], [Quarter of Order Date])

This can be extended to other metrics as well and the result of the formula can then be used in other cases like conditional formatting cells based on the resulting metric like below:

1 Like

Hey @erin - how does this differ from a lookup with an aggregate?

@data_katrina It’s the same thing.