Unwanted "Total" in Data Field in Pivot Table

E

ExcelMonkey

I have a pivot table which looks like this:


2004--------Run1--Run2
------Q1-----$5.00-$5.50
------Q2-----$6.00-$6.50
------Q3-----$7.00-$7.50
------Q4-----$8.00-$8.50
Total 2004-$6.50-$7.00

However, when I only dump on of the runs (Run1) into the array that is
linked to the pivot table I get this:

2004--------Total
------Q1-----$5.00
------Q2-----$6.00
------Q3-----$7.00
------Q4-----$8.00
Total 2004-$6.50

Why is this? I want it to retain its name. When I highlight the
DataPivotField cells and click right on the mouse and click Field
Settings, its still says my name is Run1. But the table says "Total"

Thanks
 

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

Pivot Table Calculated Fields 4
Unwanted Total in Pivot Table row field 3
Pivot table-show Q3 and Q4 with non filtered Total 0
Pivot table -Show Q3 and Q4 with non-filtered Total 0
repeated conversion of data summarized into rows and columns 4
How do I force a pivot column if there is no data? 5
Rank in Pivot Table 4
changing year grouping in pivot table 4

Top