I have a SPList View with 2 levels of grouping.
First level is Company and the second level is 'Month - Year' which is a calculated field.
Below is the view's screen shot:
The issue is when a do a 'Export to Excel', I get all the items as the output.
How can I get this view as an Excel sheet.
Maybe, If I can dump this into a GridView and export?
Any suggestions?