Pivot Table Total Is Wrong

[dineshm030]

Hi Friends,

I have created the pivot table but the highlighted total is wrong. Could please tell me the reason?

Below the image is for your reference.

Thanks in advance.

[Anil_Babu_Samineni]

May be share sample application

[sunny_talwar]

What is your dimension and what is your expression here?

[krishnacbe]

What is your expected Total?

If it is just sum of the rows select the option Expression Tab -> Total Mode -> Sum of Rows

If you want the Expression total just provide Expression Tab -> Total Mode -> Expression Total

[kaushiknsolanki · Accepted solution]

Try this,

Sum(Aggr(Your Expression,Your dimensions))

For example.

Sum(Aggr(Sum(Sales),Region,State))

Regards,

Kaushik Solanki

[dineshm030]

Yeah It is working fine bro. Thank you so much.