Cross Table

[MK_QSL]

Dear All,
I have a table having multiple fields but don't want all of them in resulted table.

Let me know the script for this cross table.

Data and result both shown in enclosed file.

[#2]

What fields you want in this excel............

[Gysbert_Wassenaar]

See attached qvw. If you have a small number of companies maybe you should use a load per company instead of crosstable.

[MK_QSL]

Dear G Wassenaar,

Thanks for your response.

Can't we make this script dynamic as we have around 20+ companies and also, there are always + and - in companies due to new mobile introduction and old model disappearance from Market.