How can i get the row values as a dimension from a table

[#1]

Dear Friends ,

    How can I use the dimension as a row values

Ex:

     Year                    Country

                   India           AUS             USA

      2000       45               60                87

      2001       48               84                89

                                       By using this above ex I wanna use Year Country as a dimension is it possible pls help me........

[#2]

Hi abinesh,

You can use crosstable concept here.

While loading excel file, by clicking on enable transformation step you can do this.

Hope this helps.

BR

Susvith

[sunilkumarqv]

HI Abinesh

Use cross table

if ur data is like

Year	India	Aus	USA
2000	45	60	87
2001	48	84	89

in scrip

CrossTable(Country, Data)

LOAD Year,

     India,

     Aus,

     USA from data source

[sunilkumarqv]

Hi check attached

[avinashelite]

Hi Abinesh,

Try with cross table and transpose the columns according to your need. If your facing any issues, please share the sample file with data. So that we can help you out on the same.

[#6]

bro thanks ur rsp if my table look like as below means

Year                                 India                                          AUS                                 USA

                     TN              AP             Delhi              GT         ER         TY         CL     UI        OP                    

      2000       45               60                87                 56         87        54            78      98        32

      2001       48               84                89                 78        98           21            45     21          31

        I need dimension as Country name as well as State name and my pivot table look should be look like as above at the same time my datasource also same like as above

[help4qv123]

Hi,

You can pull in two ways...while pulling 1st transpose state with year later apply cross table from country. u wil get the output.

[jonathandienst]

See my post in this thread Cross table for an example of loading data in that format.