A stakeholder wants to download a freeform table with a breakdown to be able to see the full rows for the breakout. Example provided below of Category with Product breakdown, my stakeholder wants a download that shows every product row for the category.

When I highlight Category and select Download Items as CSV (Category) it just downloads the category data with no breakdown.
When I highlight Product and select Download Items as CSV (Product) it just downloads the product data with no category data.
When I highlight Category OR Product OR Category & Product and click Download Selection as CSV it will only download what is selected.
When I highlight the table and click Download Selection as CSV, it only downloads the tables with the 5 rows of the breakdown. I could in theory expand the table to show more than 5, but we will likely have situations where the rows exceed 400 anyway. This workaround would be too manual/pose issues.

Additionally my stakeholder does not want a report from data warehouse, since the data warehouse has limitations on the metrics you can include - seems you cannot build a report with custom metrics.

Anyone know a solution to this that I am missing?