Forum Discussion
Excel Pivot table - breaking out to different worksheets
Hello, Is it possible to automatically separate Pivot table results to different worksheets? for example, calculating sales commissions. Can you automatically break out pivot table data for each ...
Move your SalesPerson Names to the Page Filter area of the Pivot Table.
Then, from the Analyze context Ribbon for Pivot Table, Use the Drop Down under Pivot Table, Pivot Table Options to select Show Report Filter Pages