Click on the little grey Data tab... and drag it to the top part of the pivot
table where it says total.

"erudum" wrote:

I have data organised in columns like

salesperson, department, january sales, february sales, march sales etc

I'd like to get the pivot table to be organised in the same way. But when I
drop the sales figures into the data area the always go on top of each other,
ie

january sales
february sales
march sales
etc

How do I get data organised the way I want it without doing something with
my base data?