Sum of Rows on Count expression in Pivot Table

[#1]

I need a way to get the sum of rows of my expression on the bottom of the pivot chart. At it's most basic it is just a count distinct expression with a little set analyisis.

I have looked on these forums and found a lot of comments about using aggr(function , dim1, dim2 ), but when I use this, the total is blank,

Any help would be appreciated !

Thanks,

Kevin

[swuehl · Accepted solution]

Yes, using advanced aggregation might be the way to go, look also in the Help for 'sum-of-rows in a pivot table using advanced aggregation'. You may just need an outer aggregation function:

=sum( aggr( function, dim1, dim2))

e.g.

=sum( aggr( count(Distinct Customer), Customer, Country))

[#3]

The additional aggregational sum feature worked. Thanks swuehl