I was wondering if it's possible to filter a single pivot table column in excel. In other words, when you summarize the data by count, that the data for a certain column is only counted if it has a certain value.
我想知道是否有可能在excel中筛选一个数据透视表列。换句话说，当您按计数汇总数据时，某个列的数据只有在具有一定值的情况下才被计算。
I know that it's possible to get these values by report filtering, but then I need a separate pivot table for the values I don't want to be filtered. Also, some values are 0 and thus are not displayed if report-filtered. Changing the option to display 0 values doesn't change anything. Thanks in advance.
我知道通过报表过滤可以得到这些值，但是我需要一个单独的数据透视表来过滤我不想过滤的值。此外，有些值为0，因此如果报告过滤，则不会显示。将选项更改为显示0值不会改变任何东西。提前谢谢。
1 个解决方案
#1
11
Yes, you can add a filter to a pivot report by selecting a cell that borders the table (but is outside the pivot area) and choosing Filter from the Data tab.
是的，您可以通过选择与表相邻的单元格(但不在主区域内)并从Data选项卡中选择filter，向pivot报表添加过滤器。
To add a filter to just the Count Of column select the cell above and the cell containing the title and then choose the Filter option from the menus as shown...
要向列的计数添加过滤器，请选择上面的单元格和包含标题的单元格，然后从菜单中选择filter选项，如下所示…
#1
11
Yes, you can add a filter to a pivot report by selecting a cell that borders the table (but is outside the pivot area) and choosing Filter from the Data tab.
是的，您可以通过选择与表相邻的单元格(但不在主区域内)并从Data选项卡中选择filter，向pivot报表添加过滤器。
To add a filter to just the Count Of column select the cell above and the cell containing the title and then choose the Filter option from the menus as shown...
要向列的计数添加过滤器，请选择上面的单元格和包含标题的单元格，然后从菜单中选择filter选项，如下所示…