Pivot Table for same product with different unit costs

[alejandra2011]

How can I create a pivot table that shows the same product with different rates? I am struggling to create this. It will just show it as sum of unit price and i want each individual sum of unit price to show up.

 

[johnny51981]

Drag your Unit Price into the same location as your Product identifier, which should either be in the Rows or Columns. I'm assuming that you currently have it in the Values section.

 

[alejandra2011]

This is how i have it set up but is there a cleaner way?

 

[johnny51981]

Right click on the pivot and select options.
Then in the display tab, check the box next to Classic View.