Anomandaris
03-25-2009, 09:42 AM
Hi guys,
I'm having problems displaying the right information in a pivot table....I've got the data on the file, and two different pivot tables from that info.
As you can see I'm trying to get Average Price and Total quantity/lots for each section.
The first table is quite ugly and inefficient for obvious reasons, the second one shows price and quantity in separate columns but fails to add up the quantity for each 'CODE'.
Any idea how i can fix this? I've been at it for 4 hrs and this is what I've got.....
it would be ideal if I could plug in a formula into a cell but these pivot tables dont allow that
Thanks
I'm having problems displaying the right information in a pivot table....I've got the data on the file, and two different pivot tables from that info.
As you can see I'm trying to get Average Price and Total quantity/lots for each section.
The first table is quite ugly and inefficient for obvious reasons, the second one shows price and quantity in separate columns but fails to add up the quantity for each 'CODE'.
Any idea how i can fix this? I've been at it for 4 hrs and this is what I've got.....
it would be ideal if I could plug in a formula into a cell but these pivot tables dont allow that
Thanks