Sum of average value in Pivot chart

[tamilarasu]

Hi All,

In pivot table I need to find the total sum of average for all tables. But I got wrong value for total sum of average for each day.

Please see the attachment. Can anyone help me on this.

Thank you in advance.

Kind Regards,

Tamil

[tresesco]

Trying this expression:

If(SecondaryDimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))

[tamilarasu]

Hi Tresesco,

Thank you for the reply. I have tried and still getting the same result.

[jagan]

Hi,

Try this expression

Sum(Aggr(Avg(Sales), Country, day))

Regards,

Jagan.

[kushalthakral]

Hi Tamil

i have tried, please check the screenshot below:

[tamilarasu]

Hi Jagan,

Thanks working fine and I will mark it as correct answer.. I have one more request. Is it possible to get total sum of all average values instead of average of all average values like below screenshot.?

[tamilarasu]

Hi Kushal,

Yes. Its working. Thank you for checking.

[jagan]

Hi,

What is your expected value?

Regards,

Jagan.

[tamilarasu]

It should be displayed as 3798 in total. I have attached screenshot above.

[#10]

Just for the Records, this one also works and place the - in the upper rows.

IF (Dimensionality()=0, RangeSum(top(avg(Sales),1,NoOfRows())))