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 pivot tables across 2 tabs and am looking for the best way to combine these please.

 

Thanks

 

excel
Formulas and Functions
Macros and VBA

5 Replies

      • 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

         

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 30, 2020

    raquelbuzz65 

    You may add to the weekly sales pivottable the sales ones more and adjust setting as

    Or that's not te only difference between pivottables?

    • raquelbuzz65's avatar
      raquelbuzz65
      Copper Contributor
      Mar 30, 2020
      thanks.
      i have done that for one of my views.
      i want to be able to toggle between as one staff member might prefer to look at total sales ans the other weekly change, rather than having to look at 2 different tables

Resources