Pivot Question

[MSIsam]

I have a pivot table with the following format

Reg  Div  M1  M2 
ABC  100  10  20 
     101  20  80 
     102  10  30 
DEF  100  10  20 
     101  20  80 
     102  10  30

I would like to create a 3rd metric that is M1/M2

Reg  Div  M1  M2  [b]M3[/b]
ABC  100  10  20  50%
     101  20  80  25%
     102  10  30  33%
DEF  100  10  20  50%
     101  20  80  25%
     102  10  30  33%

How would I do this using within the pivot table?

Thanks for any help on this,
Sam

 

[ETID]

Look in the pivot table toolbar for formula>calculated field.

follow the wizard