I'm looking for a way to display a count of of the number of hidden rows represented by a rolled up field in a Pivot. For instance I have a pivot table for customers that groups them by A, B, or C. When the pivot table is rolled up it shows the data just for the groups (A, B, and C). For example the total sales for A customers, B customers, etc. I can click on the + sign by the A customers to see what customers are in group A.
What I'm looking to do is have the pivot show me a COUNT of the customers that are hidden under that group (without expanding the group by cliciing the +). Ideally putting this in a field that I could also do calcs on. For instance there are 20 customers in Group A, 70 customers in Group B, and 10 customers in Group C (all hidden unless I expand by clicking +). I would like to show these counts next to each group while leaving them collapsed.
I'd like it within the pivot so it is dynamic as I change various filters.
Thank you for any help you can offer on this. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o> </o>
What I'm looking to do is have the pivot show me a COUNT of the customers that are hidden under that group (without expanding the group by cliciing the +). Ideally putting this in a field that I could also do calcs on. For instance there are 20 customers in Group A, 70 customers in Group B, and 10 customers in Group C (all hidden unless I expand by clicking +). I would like to show these counts next to each group while leaving them collapsed.
I'd like it within the pivot so it is dynamic as I change various filters.
Thank you for any help you can offer on this. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o
> </o>
