How to create Crosstable with multiple dimensions and multiple measures ?

[Anonymous]

I have attached the sample excel file which needs to be transformed using crosstable.

can anyone please help me out here.

Regards,

Ranjitha

[Gysbert_Wassenaar · Accepted solution]

With this: https://community.qlik.com/t5/QlikView-Documents/multi-header-pivot-import-qvw/ta-p/1487398

See attached qvw.

[Anonymous]

Thank you Gysbert!