Please respond: Need to create additional measure in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Have you tried this in a calculated field?

Right click in the pivot table – Formulas – Calculated field
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
pivot table chart 7
How do I perform extended calculations in a Pivot Table in Excel 2 4
Referencing a pivot tables Grand Totals Column 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot tables - memory issues - please help 2
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Back
Top