Pivot table

ales

New Member
Joined
Apr 23, 2002
Messages
21
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top