Hi,

I would like to know that Is there any possibility that we can compare different data in a pivot

for ex.
Data 1 no of products : Data 2: Rate per prodcut Data required in pivot
A - 10 no. A - £20 a=10*£20=200
B - 50 no. B - £40 b=50*£40=2000
C - 70 no. C - £30 c=70*£30=2100
D - 20 no. D - £50 D=10*£20=200
E - 40 no. F - £10 e=40*£10=400


Is it possible to "Data required in pivot" column in pivot table, if yes what is the procedure / formula to do this.

Thanks