Excel filter out groups from pivot table when there is only 1 subgroup

Question

I'm using the pivot table wth the structure below:

I want to add a filter that only displays the letter groups that have more than one subgroup, so in this example, A, C, D, & E would all be filtered out since they only have 1 subgroup, and B would remain since it has 2 subgroups. How can i achieve this filtering?

Michal · Accepted Answer · 2025-03-14 02:36:43Z

1

If you add your table to a data model in Power Pivot you can create a new measure =CALCULATE(DISTINCTCOUNT(Range[Subrow]),ALL(Range[Subrow])). Add this measure to your pivot table in the values section and filter one it.

answered Mar 14 at 2:36

Michal

7,6744 gold badges30 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel filter out groups from pivot table when there is only 1 subgroup

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related