View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Angel
 
Posts: n/a
Default Please respond: Need to create additional measure in pivot table

I' ve just started with the creation of pivot tables

I have 2 columns in my pivot table. 1) Spend at Merchant 2) Spend in Total
Industry.

Now I would like to create an additional measure (index) to compare both
measures. Outcome should be an index around +/- 100. Can I do this in a pivot
table?