Hi Friends, would like to know how to sort out prices of items having different unit prices. I tried all the options in the Pivot table.For example Item A sold to customer 1,2,3,4,5 with different unit prices and Qty when I do pivot it's taking the sum taking the sum. I tried the average,max but not getting the excat unit prices. I need to get the exact unit prices for each items. Pls help me to sort this out. Thank you
Getting the unit prices in Pivot table
- Thread starter Shifas NS
- Start date
PCosta87
Well-Known Member
Hi,
First things first... welcome to the forum
For the Pivot Table to show the various unit prices, you can go several different ways, depending on what you want in the end.
So, assuming you just want to display items and prices, you can do it like:
or something like:
Now, let's play with a different scenario.
Imagine that for the same customer you sold the same item with 2 different prices (one had a Qty discount, for example).
In this case, the latter will not work because you are telling it to display the prices by customer. No option (sum, average, max, ...) will separate the prices:
Here you can either display it like:
or use something that allows that separation, something tied to that specific price (the invoice number, the date or even the qty assuming that is related to the practiced price):
Hope this helps
Hi There,
Thank you so much for your response.However, am still can't get it.
Could you please mention under which function in Pivot table I should do this.
For example in the Pivot field list we have filters, columns,rows and values. In this which filed I have to bring the customers and the unit prices?
Kindly advise.
Thank you so much for your response.However, am still can't get it.
Could you please mention under which function in Pivot table I should do this.
For example in the Pivot field list we have filters, columns,rows and values. In this which filed I have to bring the customers and the unit prices?
Kindly advise.