What is CrossTable

[nikhilgarg]

HEllo ,

Can any one tell me what is a cross table with suitable example ??

[MK_QSL · Accepted solution]

Consider that you have below table...

Temp:

Load * Inline

[

  Customer, 2011, 2012, 2013, 2014

  A, 100, 120, 160, 90

  B, 110, 60, 70, 80

  C, 120, 40, 100, 120

  D, 95, 180, 200, 300

];

Crosstable will convert this data in Customer, Year, Sales Format as below..

CrossTable(Year,Sales)

Load * Resident Temp;

Drop Table Temp;

[Gysbert_Wassenaar]

See this blog post: The Crosstable Load

[its_anandrjs]

Hi Nikhil,

Read this post that will help you.

Cross Table

Regards

Anand