Pivot Table Combination Filtering

Question

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 over 2 million combinations. Yikes. So I need a way to filter out rows of the pivot table based on certain combinations of categories that I know aren't possible or desired. i.e. delete/filter any combinations with wall thickness of .049 and bend angle of 12"

Any help is appreciated. Thanks!

jkpieterse · Answer

Have you tried the filter options of the pivot table?

nick kopycinski · Answer

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.

jkpieterse · Answer

Without seeing your data and PT this is really hard to understand :-)

nick kopycinski · Answer

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.&nbsp;&nbsp;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.&nbsp;

john twohig · Answer

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.

Forum Discussion

Pivot Table Combination Filtering

5 Replies

Resources