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?

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?

• excel
• pivot-table

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