Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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........
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
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
Hi check attached
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.
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
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.
See my post in this thread Cross table for an example of loading data in that format.