Pivot Table total not proper

[brijesh1991]

Hi all,

I had a pivot table like this containing two dimentions Region and Campain and one expression: count(case): As shown in attached image: I had take horizonal total by checking show partial sum for Campain Dimention. But this total is not coming perfect. For example: for Guj, it shoud come 30, but in my application it's not 30. all the '?' indicates invalid total.
Is this a pivot table bug or can you please help me out??
Best Regards, Brijesh

[brijesh1991 · Accepted solution]

Hi All, I detected the problem. By default, Pivot table has Total Mode: Expression Total. But I wanted 'Sum Of Rows' Total Mode. Now anyone please tell me how to change that total mode from 'expression total' to 'Sum of Rows'??? Brijesh

[Gysbert_Wassenaar]

You'll need the aggr function. Something like this:

=sum( aggr(yourexpression, Region, Campaign))