layout of pivot table

suzzie09

New Member
Joined
Sep 21, 2002
Messages
2
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
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,931
On 2002-09-22 23:00, suzzie09 wrote:
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
Hi Dawn and welcome to the board.

I think that in your case there is no need to use PivotTable. Pivot tables are for handling (summation, count, etc) large repeatible data, arranging them in table form. In your case you do not sum or count your data which is unique for all countries and categories.

This is my oppinion but maybe someone will think otherwise.

Any way what is the setup of your original data- of which you are trying to do a Pivot table?

Eli
This message was edited by eliW on 2002-09-23 01:11
 

suzzie09

New Member
Joined
Sep 21, 2002
Messages
2
the raw data is in this form:
Country | Rates | Telco
Australia| $XXX | Stel
Australia| $XXX | page
Australia| $XXX | M1
Australia| $XXX | Sb ... for all the Telco
then i would do a pivot table on this set of info...
Yeah i agree that Pivot table is not deem necc, but this is required of me to do it in my workplace to rank them acc so. I thot using the pivot table would shorten the time spent on this, else i will have to rank them using formulae.
Thanks for your help.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,575
Members
414,390
Latest member
plimbu

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
Top