I have two value columns that I want to add to a pivot table, one an average, and one a sum.
When I add either one to the table, it look fine. When I try to add the other one, there is new entry in the Column Labels box that says values (essentially, all my averages or sums get turned into individual columns. That is NOT what I want).
I just want the two sets of columns (one is a set, one I want to be ignored by the current column labels) to exist peaceably side by side, resulting in a grand total one more column in the pivot table, as if the second value column was just another column that was part of the table.
Can this be done?
Edit: Assume my data has five columns; Name, Area, Price, Type, and Satisfaction. I want the companies grouped by area, have the prices for all the rows that contain an interaction with a company in an area summed with a breakdown by type shown, and have a satisfaction rating for the company in that area shown.
I use column labels, and a value to do the first part, but then when I try to do the second part, the column labels interfere.