Forum Discussion

Karen Gorsky's avatar
Karen Gorsky
Copper Contributor
Sep 08, 2017

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 sales person to different worksheets?

Thanks for your help,

Karen

excel

1 Reply

  • Brian Spiller's avatar
    Brian Spiller
    Brass Contributor
    Sep 08, 2017

    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

     

Resources