Pivot Table Calculated Fields formula

[Mufflon]

Hi, I have a very large database in excel where I have created dynamic columns (I think they are called that); they are just columns with formulas referencing the data in the database.

One formula looks like this: "=MAXIFS([OP];[Year];[@Year];[Client segment];[@[Client segment]];[Survey];[@Survey];[Country];[@Country])"

The formula works fine, but because the database is so large, it becomes very hard to work with, especially with all the dynamic columns. So my question is this:

Is it possible to translate that formula to a "Pivot Table Calculated Field"-formula? Perhaps this will make the database easier to work with, when all those extra columns are just created as Calculated Fields in the Pivot Table...

Regards,
Kim

 

[RoryA]

In a pivot table, you can choose to display a field as the Max value. The filters will be applied automatically by the row/column fields and the report filter.