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.