Please i have this cross table
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:
LOAD *, If(Sales='Sales',City, Peek(Month)) as Month;
load * Inline [
LOAD City, Sales, Month Resident Temp
Where Sales <> 'Sales';
DROP Table Temp;
Retrieving data ...