Pivot Table: Sum The Averages

[rohi__]

Hello everyone,

can I display the Average Values in a Pivot-Table if it is expanded, but if it is collapsed it should not take the Average of all Values but the Sum of the Average...?

Right now i just used "Avg(duration)" on the measure field in the Pivot Table.

Thank you in advance!

[sunny_talwar]

May be like this

Sum(Aggr(Avg(duration), Dimension/s))

[rohi__]

Thank you for your fast reply @sunny_talwar !

If enter the Dimension that I am using, I am just getting "0"'s... 

Is there an explanation which Dimension / s I should use?

Thank you for your advice!

[sunny_talwar · Accepted solution]

The dimension from your chart

[rohi__]

I used all the Dimensions from my Chart and it worked. Thanks @sunny_talwar 

[sunny_talwar]

Awesome!!