Position fields in PivotTable like AutoFormat

[Piers 2k]

Hi All,

I seem to have trawled every setting but can't find this.

If you insert two fields into the Data Items section, they appear below
each other, but if you format with some of the AutoFormat's, such as
Report 4, then they appear next to each other.

How can I position them next to each other without using the AutoFormat
option?

TIA,

Piers

 

[Debra Dalgleish]

In the pivot table, drag the Data button onto the cell that contains the
word Total.

There's a picture here:

http://www.contextures.com/xlPivot02.html

 

[Piers 2k]

Arrgghh! At last - thanks!