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
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