You need to use a PivotTable to summarize, review, take a look at, and present summary information. PivotCharts complement PivotTables by incorporating visualizations to your summary details in a PivotTable, and let you very easily see comparisons, patterns, and trends. Each PivotTables and PivotCharts help you to make educated decisions https://salesforceadvancedtraining.blogspot.com/2024/09/mastering-presentation-design-deep-dive.html