admin管理员组

文章数量:1391999

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
Share Improve this question asked Mar 14 at 1:43 Roger99Roger99 1,0122 gold badges14 silver badges43 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 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.

本文标签： Excel filter out groups from pivot table when there is only 1 subgroupStack Overflow

版权声明：本文标题：Excel filter out groups from pivot table when there is only 1 subgroup - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744677020a2619173.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。