topic Pivot Table: Sum The Averages in App Development

Pivot Table: Sum The Averages

rohi__ — Sat, 16 Nov 2024 20:16:36 GMT

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!

Re: Pivot Table: Sum The Averages

sunny_talwar — Tue, 13 Aug 2019 18:24:02 GMT

May be like this

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

Re: Pivot Table: Sum The Averages

rohi__ — Wed, 14 Aug 2019 06:59:59 GMT

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!

Re: Pivot Table: Sum The Averages

sunny_talwar — Wed, 14 Aug 2019 10:59:42 GMT

The dimension from your chart

Re: Pivot Table: Sum The Averages

rohi__ — Wed, 14 Aug 2019 13:16:20 GMT

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

Re: Pivot Table: Sum The Averages

sunny_talwar — Wed, 14 Aug 2019 13:17:04 GMT

Awesome!!