Control expression total in pivot table

[dafnis14]

Hi,

In a pivot table, I use the following expression to show difference which will be presented in % :

[Actual Demand]/[Optimal Demand]-1

But in the Total, it shows the sum of all the differences.

Is it possible to control this behavior to show the average in the total?

Thanks!

[rubenmarin · Accepted solution]

Hard to say without a sample.. I would guess something like this will help you:

If(Dimensionality()>0, [Actual Demand]/[Optimal Demand]-1,

Avg(Aggr([Actual Demand]/[Optimal Demand]-1, Dimension1, Dimension2...))

)

[dafnis14]

Thank You!