Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My pivot table having 2-dimensions
State and city and my expression is count(Distinct Appnum)
In presentation i have check show partial sum for both dimensions but for city some othem were showing sub total and some of them weren't showing sub total.Kindly help on this.
Thanks..
can u share sample?
try
= Count(Aggr(Distinct Appnum))
do you have Appnum for all the city ??? is not then due to null values the partial sum may not be displaying
plz share the sample data..
If you have the "Suppress Zero-Values" option checked, then zero partial sums will be suppressed as well. Uncheck the option to see the zero partial sums.