Pivot Table (from Database): count total of grouped items

[Hugo_de_Vries]

Hi everyone,

Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name?
For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed.
Alternatively, B3 would show the number 12 (also when Accessoires is collapsed).

Thanks for your help, Excel-Gurus!

PS: Don't be scared. It's German but it doesn't bite .

 

[JustynaMK]

Hi Hugo,

I don't think customizing the Row Label itself is possible. You might want to drag your "Level 2" field into "Values" and change the aggregation method to Count - this way, the count of fields will be always visible in column B, regardless if it is collapsed or not.

P.S. By "Level 2", I mean the field where "Brillen Zubehor", "Cap", etc. are stored.
P.S.2 German is an awesome language

 

[Hugo_de_Vries]

Hi JustynaMK,

Thanks very much for your reply! I know in a "normal" Pivot, you can do that and use "Show Field Value > Count".
In this Database, that doesn't work. Perhaps because Level 2 contains a Level 3...

If you know any other solution, I'd be very grateful!

Best,
Hugo

 

[sandy666]

is it possible to see source data from database (with generic values but the same structure) ?
use xl2bb to post copyable data

 

[sandy666]

example