cross table load

[srikanth1994]

hi friends ,

I have a data like this i need to do cross table 

can anyone help me with the expression ,

	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19
Revenue	433,103	416,756	424,787	424,457	441,999	439,205
COS	383,986	367,170	351,189	372,222	399,951	385,404
Customer Access & Backbone cost	291,149	270,956	264,859	272,044	298,574	289,660
Remaining access cost	3,753	1,068	(0)	1,109	597	6
Colocation cost	74,855	71,191	62,580	77,787	76,696	73,359
Other NS cost	14,229	23,955	23,750	21,282	24,084	22,378
Market Prizm	0	0	0	0	0	0
Asset Sale	0	0	0	0	0	0
Contribution	49,117	49,586	73,598	52,235	42,049	53,801
Contribution %	11%	12%	17%	12%	10%	12%
TLC	0	0	0	0	0	0
Base Pay	0	0	0	0	0	0
Annual Bonus	0	0	0	0	0	0
Commissions	0	0	0	0	0	0
Benefits	0	0	0	0	0	0
Total Personnel cost	0	0	0	0	0	0
Recruitment	0	0	0	0	0	0
Training	0	0	0	0	0	0
Other Personnel	0	0	0	0	0	0
Capitalised labour	0	0	0	0	0	0
Net Personnel Cost	0	0	0	0	0	0
Other Cost	0	0	0	0	0	0
Total Operating Costs	0	0	0	0	0	0
EBITDA	49,117	49,586	73,598	52,235	42,049	53,801
EBITDA %	11%	12%	17%	12%	10%	12%

[MarcoWedel]

one example:

tabTemp:
CrossTable(MonthYear,sales)
LOAD * FROM [https://community.qlik.com/t5/New-to-Qlik-Sense/cross-table-load/td-p/1964804] (html, codepage is 1252, embedded labels, table is @1);

tabSales:
LOAD *,
     Month(MonthYear) as Month,
     Year(MonthYear) as Year;
LOAD F1 as Category,
     Date#(MonthYear,'MMM-YY') as MonthYear,
     sales
Resident tabTemp;

DROP Table tabTemp;

hope this helps

Marco