Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please i have this cross table
July | Sales |
---|---|
Cairo | 200 |
Alex | 300 |
August | Sales |
Cairo | 400 |
Alex | 500 |
i nedd to load it and make (july,August) as dimension "Month"
and make (Cairo,Alex) as dimension "Country"
How to do that?
For your test data , the following script will help:
Temp:
LOAD *, If(Sales='Sales',City, Peek(Month)) as Month;
load * Inline [
City, Sales
July,Sales
Cairo,200
Alex,300
August,Sales
Cairo,400
Alex,500
];
Data:
NoConcatenate
LOAD City, Sales, Month Resident Temp
Where Sales <> 'Sales';
DROP Table Temp;