If I have a table of data including three columns of similar data, if there a way for a Pivot Table to count an entry across the multiple columns?
For instance, if I had a list of items that were each assembled from one, two, or three parts (any given part could show up in column 1, 2, or 3) and wanted to use a Pivot Table to count how many items of a particular class included part #415 regardless of which column it was in ... or the average price of items that include part #248, etc.
At present, I've using one Pivot Table and toggling between part1, part2, and part3 entries and adding the results together or setting a filter for each of the three, but there has to be a more elegant solution.
Bookmarks