Pivot Table Total Issue....

[infosense_devel]

Hello All,

I have created one pivot table taken Operating Unit, Month, year, Group as dimension and rest in expression I want to do total for all Expression for all group something like this attached below.

I have tried show partial sum in presentation tab based on Group dimension but it doesn't show the expected result.

Thanks in Advance.

[swuehl]

Using a partial sum should get you a result like shown in the image.

What do you get instead? (And what's the expected result if that's not shown in the attached image)?

[sunny_talwar]

What is the expression you are using? Are there if statement in it? May be you need Aggr() function to make this work

Sum(Aggr(YourExpression, [Operating Unit], Month, Year, Group))