What’s a PivotTable?
The best way to understand what PivotTables are and how they operate is… to create one and experiment with it! The following example creates a PivotTable showing the total sales values of the top 10 best-selling products in an Excel table containing just over 2,000 invoices.
Read more here: https://www.aatcomment.org.uk/?s=pivot+table