Pivote issue

[Mahamed_Qlik]

Hi Expert,

I am facing one issue while exporting pivot table to excel.

I want the result to be seen as in Pivote12 snapshop but currently after export it shwoing me result in Pivote21 snapshots.

Both the snapshots attached.

More clarification- First column is getting expanded in the export excel which I dont want it should show only one value.

Kindly assist.

[andrey_krylov]

Hi, Mahamed. As I know exporting to excel gives you a straight table, not pivot. You can achieve that with a macro or copying a table straight from an application and pasting to excel.