2 Replies Latest reply: Jul 12, 2016 8:32 AM by Mark O'Donovan RSS

    Nprinting 16 - Pivot tables on Multiple Worksheets

    Mark O'Donovan

      Hi all,

       

      I'm trying to create 1 pivot table on separate worksheets, 1 per region.

      The source data is in 1 worksheet.

       

      I have added a page to the sheet that contains the pivot table.

       

      Now I would like to filter the pivot table by region.

       

      Is there a simple way to do this ?

       

      Would have been nice if the Excel 'Show Filter Report Pages...' worked.

       

      When I try to put the data in the same worksheet as the pivot table I get a 'Reference is not valid' error.

       

       

      Thanks

       

      Mark