Selectively display data in a pivot table

[#1]

I have a data file as shown on the left, i would like to display it in a pivot table as shown on the right.

 

My question is how do i selectively display the price according to the Volume.

e.g. For Prod1, Cust1 and S1, there are two rows, shown as below. I only want to display the price (0.352) which has bigger volume.

Thank you in advance for your help!

[swuehl · Accepted solution]

Try something like

=FirstSortedValue(DISTINCT Price, -Volume)

as your expression with the three dimensions mentioned above.

[#3]

Thank you, swuehl. It works.