Crosstable from a Binary

[julioarriaga]

Hi,

I have a table from a binary load that goes more or less like Image 1 and I would like to order like Image 2 (Gross Salues, Returns, etc), but I'm not sure how the syntax of "crosstable" would work as there is a field ("Period Type") in the middle.

Thanks in advance.

(Image 1)

(Image 2)

[sunny_talwar · Accepted solution]

Lets assume the table is called Table1... you can do like this

CrossTable:

CrossTable(Item, Value)

LOAD Period,

     [Gross Sales],

     [Returns],

     [Total Off Invoice],

     [Rebates],

     [BillBacks],

     [Co-op]

Resident Table1;

DROP Table Table1;

[jonathandienst]

Or if you would like to keep [Period Type]:

CrossTable:

CrossTable(Item, Value, 2)

LOAD Period,

    [Period Type],

    [Gross Sales],

    [Returns],

    [Total Off Invoice],

    [Rebates],

    [BillBacks],

    [Co-op]

Resident Table1;

DROP Table Table1;

[julioarriaga]

If I could mark two posts as correct answers, I would . Thank you for your input, this is also correct.