Operations within Pivot Table

R

Rick Palmer

OK, I have a worksheet that has a pivot table that summarizes a report by
month. The table summates two columns for the "data" area of the table. I
need to be able to divide one of those column totals by the other within the
report. Is this possible????
 
B

BrianB

Insert a calculated field into the pivot table.

Click somewhere in the table and then menu - Insert/Calculated Field.

Regards
BrianB
=====================================
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot table report invalid 0
Pivot Table: summarizing two different ways 0
Pivot Table Counting Text Issue 0
Consolidation Table from Different Excel Tabs with Different Format 1
How to have two tables on same line? 1
Pivot table 0
Embed the same Excel multiple times 0

Top