I've two content types say Reports-1 and Reports-2. Using views I've displayed them as shown in the image. Reports-2 is attachment for Reports-1.
I used Views Calc to display sum at bottom of the table. (Total SUM)
By using Views data export module I could able to export data to Excel format.
Right now the exported excel looks like follows.
But my question is is there any possibility to show the data in separate tables with headers as Reports-1 and Reports-2? (like following image) to recognize the Reports. I need to display sum as well for Individual reports.
I'm also thinking to export views in different sheet of the same Excel. Is it possible?.
Can I do modifications on views-data-export tpl files. Is there any chance to render views output there? Any hints/suggestions!! ?