Pivot table

[ales]

I have problems with pivot table, when I have 2 measures in table, for example minutes and dollars.
Example
Source table:
Month; Region; minutes; USD;
1; A; 50; 100;
1; B; 10; 150;
1; C; 20; 200;
2; A; 30; 65;
2; B; 40; 100;

What I want as a result of pivot table is something like this
Month SumOfMinutes SumOfUSD
1; 80; 450;
2; 70; 165;

and NOT what I get
Month
1 SumOfMinutes 80
SumOfUSD 450
2 SumOfMinutes 70
SumOfUSD 165

Could someone help me?

[ This Message was edited by: ales on 2002-04-24 00:27 ]

[ This Message was edited by: ales on 2002-04-24 00:28 ]

[ This Message was edited by: ales on 2002-04-24 00:28 ]

[ This Message was edited by: ales on 2002-04-24 00:29 ]

[frajaro]

Hello ales,

The solucion is quite simple, just drag the field "Data" on the right and you'll get the data in the position you need,

regards,
Francisco

[ales]

Hi, Francisco
I cant move data fields in such position, it always appears like
SumOfMinutes
SumOfUSD

and not
SumOfMinutes SumOfUSD

I use Excel 2000, not XP.

[Nobby]

Hi, ales,

Frajaro is correct in what he says.

On your pivot table, (not in the "Layout" section of the Wizard, you will have 2 grey boxes, Month & Data. It is this "Data" box that you grab and slowly drag to the right of your pivot table. As you grab it you will see a white box with a blue strpe in it. As you drag it right, the blue strip will eventually move to a different position - at that point let go and, hey presto, the table layout will be exactly what you want.

Nobby

[ales]

Thanks a lot both of you,
I didn't know that I can't do that with the wizard. It works now, and you really help me a lot.

Ales