Add option to hide Pivot Table (v2) totals and metric label

What is the problem or goal you're trying to solve or accomplish?

Customers building Pivot Table charts to display records side-by-side for comparison (e.g. one column per employee, product, or entity) don't want the automatically generated Total/Grand Total row, or the "Metric" axis label row that appears when multiple metrics or row fields are used. There's currently no built-in toggle in the chart's Customize panel to hide either of these, unlike the Table chart which does have a totals toggle.

How are you solving it currently?

Workaround via custom CSS added at the dashboard level (Dashboard properties > Advanced > CSS), targeting the pivot table's internal class names (pvtTotal, pvtGrandTotal, pvtTotalLabel, pvtRowTotalLabel, pvtAxisLabel). This works but has real limitations:

• Only applies when the chart is placed on a dashboard, not in the standalone Explore/chart view

• Relies on undocumented internal library class names (react-pivottable), which could break silently on a future Superset upgrade

• Required extra tuning to avoid a rowspan rendering bug in Chrome/Safari when hiding rows via display:none (visibility:collapse plus manual height/padding resets were needed to fully resolve it)

What is your recommended solution?

Add native toggles in the Pivot Table (v2) Customize panel, similar to the existing Table chart's "Show totals" option:

• "Hide totals" (row/column/grand totals)

• "Hide metric label" (the axis label row shown above column headers when metrics are used)
  This would remove the need for CSS workarounds and make the behavior consistent and upgrade-safe.