Calculate a pivot table that has consolidated multiple worksheets

J

JBox

I am trying to calculate within a pivot table that has consolidated multiple
worksheets. I need to add two item fields together and then divide the
answer by the third item field. Does anyone know how to do this?
 

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 Email Accounts and Calendars 0
Dealing with a Pivot Table (when I don't want to) 0
Combining worksheets/tables into one consolidated table (or pivot 0
Doughnut Chart linked with the slicer in the pivot table 0
Consolidated Pivot table 1
Pivot Table cell values 1
Calculate the median value before a specified list 0
Creating a Search using a combo box and then creating a report. 4

Top