Forum Discussion
Pivot Table Combination Filtering
I have a table with several categories. Each category has a number of values. I created a pivot table which displays all possible combinations of these values. Now, all said and done, there would be ...
Have you tried the filter options of the pivot table?
Ya, but I cannot select multiple fields as the criteria for filtering the entire table. I can only filter one field at a time based on a relation referring to just that field.
I want to filter an entire row, one whole combination of the categories, based on a specified combination of two or more categories.
- Without seeing your data and PT this is really hard to understand :-)
I quickly created this table and pivot table which is identical in practice to my much larger list. The pivot table displays all combinations of the items of the 3 different categories.
Now, lets say I do not want any combinations of small squares and I don't want any blue circles. Is there a way to filter all of the rows with those conditions.
