Unwanted "Total" in Data Field in Pivot Table
 

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


---
Message posted from http://www.ExcelForum.com/