Pivot Table Lay Out

[neildfaux]

Does anyone know if it is possible to chnage the layout of the "Data"
section of a pivot table in excel? In Access, when you run a pivot
form, you can have multiple data points shown side-by-side (i.e. Count
& Sum). In excel, it stackes these on top of each other.

 

[Random Poster]

(e-mail address removed) wrote in @z14g2000cwz.googlegroups.com:

Does anyone know if it is possible to chnage the layout of the "Data"
section of a pivot table in excel? In Access, when you run a pivot
form, you can have multiple data points shown side-by-side (i.e. Count
& Sum). In excel, it stackes these on top of each other.

It can be done. Actually, I wish it was the default position. After you
create the table, drag the "Data" label to the right, towards the column
field region. Watch the mouse icon, it should change when you get to the
right spot.


-RP

 

[Roger Govier]

Hi Neil

Just Drag the Data Button and drop it onto Total and you will get the
columns side by side.

Regards

Roger Govier

 

[FuzzyD]

Hey Folks,

Would it not help to just go to the "Format Report" wizard and choose any one of those Tables available? That's how i get my Pivot Data fields to stack side by side.

Sorry if this does not answer your query. Am actually quite a novice !

This is a great forum Just joined today and I've already got to learn so much. Nice to be here !!