Hi,
I have a pivot table which will look like the attached image.
i have a table with vegetable names as field values.
i have dragged it and dropped in the horizontal way, so it appear as a column name in the pivot table.
In QlikView, the metric1 and metric2 field in table takes a common vegetable name in pivot table,
This is the table in QlikView (Sorry i couldnt attach the image)
| ID | Brinjal | Capsicum |
|---|
| Metric1 Metric2 | Metric1 Metric2 |
| 1 | 10 30 | 10 45 |
| 2 | 20 40 | 20 50 |
| ID | Brinjal Brinjal | Capsicum Capsicum |
|---|
| Metric1 Metric2 | Metric1 Metric2 |
| 1 | 10 30 | 10 45 |
but the same table after exporting to excel, each metric1 and metric2 will have individual vegetable name like brinjal, brinjal twice.
The grouping is lost, after exporting to excel, i need that grouping in excel also.
How can we get that?
Not possible without a macro, and this macro must have system access.