go to the cell you want to put the formula in
enter = then click on the cell you want to multiply then enter *2, copy down
repeat the same for the second field

basically you have to use GETPIVOTDATA function to get values from PIVOT
table.

let me know how it goes.

"karim" wrote:

Hi,
I have a grouped pivot table that looks like this:

Group1 Group2
Item 2007 2008-Q2 2007 2008-Q2
A $50 $30 $100 $55
B $25 $10 $150 $60
C $115 $65 $100 $75


For each group, I am trying to create 2 calculated columns:
2008-Q4: multiplies 2008-Q2 items by 2
%difference: 2008-Q4 to 2007 % increase or decrease
the data sould look something like this at the end:

Group1
Group2
Item 2007 2008-Q2 2008-Q4 %Diff 2007
2008-Q2
A $50 $30 $60 +20% $100
$55
B $25 $10 $20 -20% $150
$60
C $115 $65 $130 +13% $100
$75

I tried to use calculated fields and it doesn't seem to work for me.
Anyone can help
Thanks,
Karim