Sub total in pivot table

[nareshthavidishetty]

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..

[Chanty4u]

can u share sample?

[Chanty4u]

try

= Count(Aggr(Distinct Appnum))

[avinashelite]

do you have Appnum for all the city ??? is not then due to null values the partial sum may not be displaying

[Anonymous]

plz share the sample data..

[jonathandienst]

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.