Pivot Table Lay Out

N

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.
 
R

Random Poster

[email protected] 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.
Click to expand...


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
 
R

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
 
Top