Excel PivotTable - Show Raw Data Value, Not Sum 1

[ryplew]

Hello!

I am utilizing a PivotTable for sales analysis. I have rows showing the item being sold and columns summing the sales from my raw data table. Within the raw data table, I also have a cost and price of each single item. While having the PivotTable show the summed totals, I would also like for it to show individual cost and price of each item. Currently, when I add these fields into the PivotTable, they auto-sum. I am unable to find a way to disregard a calculation and just show the original value. Can this be done? Thank you!!

[pre]
Raw Data
Item Qty Sales PriceOfSingleItem CostOfSingleItem
ABC 2 $10 $5 $2
ABC 4 $20 $5 $2
ABC 1 $5 $5 $2
DEF 3 $30 $10 $4
DEF 8 $80 $10 $4

PivotTable (what I get)
Item Qty Sales PriceOfSingleItem CostOfSingleItem
ABC 7 $35 $15 $6
DEF 11 $110 $20 $8

PivotTable (what I want)
Item Qty Sales PriceOfSingleItem CostOfSingleItem
ABC 7 $35 [highlight]$5 $2[/highlight]
DEF 11 $110 [highlight]$10 $4[/highlight]
[/pre]

 

[SkipVought]

Hi,

Use Average rather than Sum.

 

[ryplew]

Thank you Skip! That's it! Such a simple solution. I fear I tried to complicate it far too much.