Download error with povit table

[SettZhou]

Download error when i create a povit table with Aggregation function . And i use function : 1、show rows total 2、show rows subtotal 3、show columns total 4、show columns subtotal 5、transpose pivot.

[dosubot[bot]]

There aren't any existing tickets or documentation that directly address download errors with pivot tables when all advanced options (aggregation, show rows/columns totals and subtotals, transpose) are enabled. Recent changes to Superset's export logic—especially the backend pivot_df function—handle these features by building a complex DataFrame with MultiIndexes, inserting totals/subtotals, and flattening for CSV/Excel output. When all options are used together, this complexity can trigger backend errors or malformed downloads, especially if there are edge cases in index/column manipulation or DataFrame flattening during export [pivot_df implementation].

If possible, try disabling one or more of the advanced options (like subtotals or transpose) to see if a specific combination triggers the error. If you can share the exact error message, your Superset version, or any logs/stack traces, that would help pinpoint the root cause. Recent improvements to export functionality may also be relevant if you're on a newer version [PR 33569, PR 33357].

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}