Forum Discussion
Pivot Table Combination Filtering
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.
You could create a filter column in your data or the data model that concatenates shape and size, put it in the filter section of your pivot table, and then just untick small squares. Do the same thing for color and shape and for color and size.
