How to make pivot display unit price only

[Sean15]

Hi:

I have a pivot table set up to display unit price, quantity and totals.

I want to show single unit price but Excel is displaying sum of unit price. Data is set up as:

Full - 23.50(unit) 52(quantity) and 150 (total)
Full - 46.00

Excel is displaying unit price as $69.50 but i want to display unit price 23.50 and 46.00 separately and quantity and total for each unit price.

Could you help please?


Regards,

Sean

 

[Sean15]

Hi:

Any suggestions?


Thanks

Regards

Sean