Another Pivot Question

[brutus6294]

Have 3 fields in the DATA section of a Pivot. Looks something like this.

Sum of Field1 99999 99999 999999 9828282
Sum of Field2 88888 88888 888888 888888
Sum of Field3 7777 7777 77777 77777

The fields and field descriptions appear in the data section of the pivot. However, if I want to remove 2 of the fields from the Data section, it does not leave the remaining Field description next to the Data Section. It puts it up in the top left of the pivot table up where a Page Section would typically show. Is there a way to leave it in the Data Section? Hope that made sense.

 

[SkipVought]

Hi,

Not that I know of.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[SkipVought]

How many rows in your source data?

You could, instead of a PT, build a report format...
[tt]
Cols Fld1 Fld2 Fld3
Row_Fld Data_Fld forula here


=sumproduct((Row_Fld=$A2)*(Col_Fld=C$1)*(indirect($B2)))
[/tt]
using Named Ranges.

copy formula across and down thru data.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[brutus6294]

Could be easily 20000+ rows.... Having enough difficulty getting them used to pivots not sure I want to switch up on them now. It's not that big of a deal, it's just odd that it moves the field name when there is only one item in the Data section..