Crosstable

[polisetti]

I have a problem getting while using Crosstable .I Attached a Xl file which containing the data sample .Please give example how to use crosstable for this data

[swuehl]

I think you just need to transpose your table:

Directory;

LOAD [Date of sales],

     [Employee's last name],

     [Region of sales],

     [Number of sales]

FROM

Coomunity.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Col, Pos(Top, 1)),

Transpose()

));

[polisetti]

Hi Swuehi ,

         Thank you for your Response ,I got the output ...But can we use crosstable in this scenario...

[Gysbert_Wassenaar]

No, use the transpose function like swuehl said.