Forum Discussion

raquelbuzz65's avatar
raquelbuzz65
Copper Contributor
Mar 30, 2020

Adding a toggle to a pivot table

Hello   I have a pivot table of weekly sales data. How can i add a toggle so that one view is the total sales, and the other view is weekly change in sales? I currently have this as 2 separate pi...
excel
Formulas and Functions
Macros and VBA
Abiola1's avatar
Abiola1
MVP
Mar 30, 2020

raquelbuzz65 

 

Hello, I didn't catch what you mean by adding a "toggle"

  • raquelbuzz65's avatar
    raquelbuzz65
    Copper Contributor
    Mar 30, 2020

    Abiola1 

     

    something that easily switches between the 2 different views 

    • Abiola1's avatar
      Abiola1
      MVP
      Mar 30, 2020

      raquelbuzz65 

       

      I guess you may have to use the hidden Show Report Filter Pages. With that, you have separate report on different sheets tabs

       

Resources