Excel 2024: Replicate a Pivot Table for Each Rep
May 20, 2024 - by Bill Jelen
Here is a great trick I learned from southern California based Excel consultant Szilvia Juhasz.
The pivot table below shows products across the top and customers down the side. The pivot table is sorted so the largest customers are at the top. The Sales Rep field is in the report filter.
If you open the Rep dropdown, you can filter the data to any one sales rep.
This is a great way to create a report for each sales rep. Each report summarizes the revenue from a particular salesperson's customers, with the biggest customers at the top. And you get to see the split between the various products.