I have a worksheet as below:
I want the pivot table to return:PHP Code:
store # UPC Key Category Sales Units
123 555 123-555 soda 20
124 222 124-222 candy 10
123 555 123-555 soda 15
I created the pivot to combine duplicates by location and UPC, so I created a the "key" column to do that: =a1&"-"&b1PHP Code:
store # UPC Key Category Sales Units
123 555 123-555 soda 35
124 222 124-222 candy 10
The challenge I have in excel 2007 is I cannot get the Category as a column in the pivot, when I include it, I get a subtotal on every key, that is not what I want, I want the actual category of that UPC, I know I can perform a lookup to the original worksheet, but there has to be an easier way?
Bookmarks