I have a report with 3 groups. Each group is a child of the one before it. The two child groups are hidden by default and have their visibility toggled by clicking its parent. Columns to the right contain aggregate values for each of the groups.
My problem is when i try to export the report to Excel there is a row added for each parent group. Viewing on the web or exporting to PDF don't have this problem.
Anyone have an idea for how to prevent this row from displaying?
This is how it looks on the web or PDF (how I want it to look):
This is how it looks when exported to Excel (do not want):