I stopped using PivotTables in Excel because I found something better
https://www.makeuseof.com/excel-pivot-tables-better-alternative/
Meet Excel’s PivotCharts
The smarter side of PivotTables
Building your first PivotChart
No formulas, just drag and drop
Make PivotCharts your own
Colors, styles, and chart types
Interactive filtering with PivotCharts
It makes data exploration way easier
When PivotCharts outshine tables
Faster insights with fewer clicks
Don’t ditch PivotTables completely
Some tasks demand raw numbers