Send to excel pivot table issue

[#1]

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?

[Anonymous]

Not possible without a macro, and this macro must have system access.