Pivot Table Sums

R

ridgerunner

I have a pivot table that will properly sum the data, but I want the sums to
go across the page instead of down the page under one another. I try to
place the second sum column across the page but the table just pulls it
under the other one. Am I trying to do something that is not possible or am
I just doing something wrong?
 
G

Geoff

You're not doing anything wrong - it's just default behaviour of pivot
tables. They will automatically arrange fields vertically in the Data region
- why I don't know :)

To fix it, drag the Data fields button (the grey box) to the right and drop
it onto the Total cell - this should rearrange the fields so they are
side-by-side.

Good luck
Geoff
 
R

ridgerunner

Thank you so much for helping. These things seem so simple when you know
what to do, but when you do not know, hours fly by while you are trying to
find a solution.
 
R

ridgerunner

I thought I had sent a 'thank you' for your help but I do not see it so,
once again, thanks so much!
 
Top