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.

wrote in news:1129819163.221301.52100
@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

Hi Neil

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

Regards

Roger Govier


wrote:
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.