Pivot table similar to Excel

[#1]

I want to create Pivot table similar to Excel (as per attached s1.jpg). But it creates an additional column (as per attached s2.jpg).

See the heading "ShipCountry". Is it possible to create the PivotTable in qlikview similar to Excel Pivot.

[#2]

Hi,

Thanks for your sample app. But can you also attach "Customers.qvd".

[muthukumar77]

no problem. you can attach your excel data same format instead of Customer qvd.