How do I insert the same field twice in an Excel 2007 pivot table

B

burtgard

In Excel XP you could just drag the field twice into your Pivot table and
calculate a sum and an average for example; how do you do the same function
in Excel 2007? I need to get the same data field into my pivot table twice.
 
F

Fred Smith

I don't see the difference. I have a pivot table created under XP, and
opened it in 2007. You just drag in the field, the same as before.

Can you be more specific with your problem?

Regards,
Fred
 

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

2007 Pivot table Calculated field misbehaving 1
Pivot Table Defaults 1
How do you insert a calculated field within a pivot table 1
Pivot Tables: Excel 2003 vs Excel 2007 2
Pivot Excel 2007 2
Pivot Table Field based on two data area fields 3
Pre-configuring Pivot table "views" 4
Pivot table summary functions 1

Top