Exporting to Excel - Pivot Grouping Issue

[#1]

Hi All,

I want to export a pivot table like the one below, but not have the exported table repeat the Group1 value.

Instead I want to achieve this result:

NOTE: I don't want to use the indent mode, unless you can configure the indent mode to display exactly the above result.

Thanks very much.

[hectorgarcia]

I also want to know how to do it.....

[suniljain]

Try Following Method

set

"E:\Qlikview\Prima\PPT\Department_Loadinng.xls"

,5

obj = ActiveDocument.GetSheetObject("CH703")