Export Matrix To Excel With Multiple Subtotals

  • I have a matrix report with 5 or 6 row groupings that have subtotals. From testing that I have done, it seems that the innermost grouping can be subtotaled and the export to Excel is successful, but as soon as I add a subtotal to an outer grouping, the export fails. Any suggestions? Thanks.

  • This was removed by the editor as SPAM

  • Does anyone have any thoughts on this? Please? Feeling desparate here. Thanks.

  • Okay, I resolved the problem. Apparently it is because at the end of my row groupings I had inserted a row grouping that didn't really group on anything, but just included some sums. I removed this, and export with multiple row grouping subtotals now works.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply