Modify and export to excel with sub totals and formats

[imhappiee]

Hi buddies,

It would be highly appreciable, if any body can help me out solving this challenge,

The challange is, as shown in excel sheet i have a chart in qlikview which contains a list of  items and the desired result is also provided just below, in the same excel sheet

Brief about the content:

- I pulled out a chart in qlikview which contains a table with quartely and monthly data

- I want this data to be tweaked in such a way that I should be able to see subtotals, sub headings at the top, Item description renamed and the formating as is shown in the attached excel, all this should be done in qlikview before getting this exported into excel using some macro

- The description on the extreme left of the table should be present in the chart even if there are no values for that item.

Eg:"cont" in the results chart.

qlikview Source chart

Excel Result chart:

please do post for any queries.

Thanks in advance for the help!!!!

find the attached excel file for quick reference

Thanks & Regards,

Anand

[imhappiee]

Any help would be highly appreciated....!!!!