hi all,
I have trouble in the layout of pivot table. this is the display which i want as an end result, but i just cannot obtain this no matter how i permuate the fields in the layout.
(This is what i want)
Country|TelcoCom Rates| TelcoCom Rates| TelcoCom Rates| TelcoCom Rates|
Australia| M1 0.0123| Sb 0.213| page 0.2144| Stel 0.231
Britain| Sb 0.21451| M1 0.2441| page 0.2451| Stel 0.2511
China| M1 0.23451| Stel 0.241| page 0.251| Sb 0.261
Germany|page 0.257| Sb 0.26| Stel 0.287| M1 0.298
India| M1 0.261| Stel 0.264| Spage 0.264| Sb 0.284
Singapore| Stel 0.215| M1 0.245| page 0.2451| Sb 0.261
Thailand| Sb 0.2164| M1 0.2341| page 0.2491| Stel 0.2516
Vietnam| page 0.2123| Stel 0.2175| Sb 0.241| M1 0.2641
Where the different fields are Country, Telcocom and Rates. the rates are arranged in descending order from left to right (cheapest to expensive) with respect to the country on the leftmost column.
Please give me the advice that i badly needed. Really appreciate that.
Thanks, Dawn
This message was edited by suzzie09 on 2002-09-22 23:02
This message was edited by suzzie09 on 2002-09-22 23:03
I have trouble in the layout of pivot table. this is the display which i want as an end result, but i just cannot obtain this no matter how i permuate the fields in the layout.
(This is what i want)
Country|TelcoCom Rates| TelcoCom Rates| TelcoCom Rates| TelcoCom Rates|
Australia| M1 0.0123| Sb 0.213| page 0.2144| Stel 0.231
Britain| Sb 0.21451| M1 0.2441| page 0.2451| Stel 0.2511
China| M1 0.23451| Stel 0.241| page 0.251| Sb 0.261
Germany|page 0.257| Sb 0.26| Stel 0.287| M1 0.298
India| M1 0.261| Stel 0.264| Spage 0.264| Sb 0.284
Singapore| Stel 0.215| M1 0.245| page 0.2451| Sb 0.261
Thailand| Sb 0.2164| M1 0.2341| page 0.2491| Stel 0.2516
Vietnam| page 0.2123| Stel 0.2175| Sb 0.241| M1 0.2641
Where the different fields are Country, Telcocom and Rates. the rates are arranged in descending order from left to right (cheapest to expensive) with respect to the country on the leftmost column.
Please give me the advice that i badly needed. Really appreciate that.
Thanks, Dawn
This message was edited by suzzie09 on 2002-09-22 23:02
This message was edited by suzzie09 on 2002-09-22 23:03