Cross Table?

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

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?

Re: Cross Table?

nagaiank — Sun, 26 May 2013 13:05:27 GMT

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;