Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a Pivot table in Excel, where I have two fields in the totals area (say, I calculate the Countof both A and B).

Is it possible to do calculations on these totals instead of just displaying them side-by-side in the totals area, e.g. display CountOfA / CountOfB, or CountOfA as a % of CountOfB?

share|improve this question

2 Answers 2

A visual way to look at how pivot tables work is of a process where every part of the process can only act upon or refer to its left:

CELLS --> FILTERS and FORMULAS --> GROUPING RESULTS --> SCREEN

As you see, FORMULAS is on the left of GROUPING. You cannot create a formula or filter based on something that doesn't exist yet (a grouping result).

So, my first answer to your question is no.

However, some workarounds are possible! For example, you can do a second pivot table based on the result of the first. You can also add columns your original cells to include something that will let you do what you need (such as duplicating the total on every row). Sometimes a different approach is in order.

If you wish to explain your problem and data more in detail, we could try to look for a workaround solution for you.

share|improve this answer
    
Hi, thanks for your help. Often I've created a second pivot table, or created formulas with reference to the first table, but I've found it cumbersome, and hoped there would be better solutions. –  grojo Jan 15 '10 at 15:16
    
I agree. I hope Excel 2010 will facilitate that sort of stuff. –  mtone Jan 15 '10 at 17:33

I may have misunderstood your question, but have you tried to create a calculated field? In Excel 2007, choose Options, Tools, Formulas, Calculated Field and enter your formula. Thus a new column is made.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.