Forum Discussion
Solved
Value filters on multiple value columns in a Pivot Table
Greetings, I know how to utilize the 'Value Filters' functionality in order to filter Pivot Table data. Is there a way to filter on the values in 2 separate columns? I need my Pivot table result...
In order to activate the filter for several pivot table columns i select cell I1 (or another adjacent cell I2 or I3 or...) with the mouse. In the screenshot you can see that I1 is the active cell. Then i select "Daten" (which is Data in english Excel) and then Filter.
Now there are filters for all columns.
Thank you for the explanation. My question is how did you get filters on 2 different columns in the 'Values' section of the pivot table? I may be missing something, but I can only apply filters from the 'Item' column (in your example) - I can't apply additional filters to any columns in the 'Value' section of the pivot table. I can convert the pivot table to a regular table and apply filters on multiple values columns that way. How did you get filters to appear on multiple values columns within the pivot table?
In order to activate the filter for several pivot table columns i select cell I1 (or another adjacent cell I2 or I3 or...) with the mouse. In the screenshot you can see that I1 is the active cell. Then i select "Daten" (which is Data in english Excel) and then Filter.
Now there are filters for all columns.
- Interesting workaround - I gave it a try and it did the trick. Thank you!