Forum Discussion

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

MVP

Mar 30, 2020

raquelbuzz65

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

raquelbuzz65

Copper Contributor

Mar 30, 2020

Abiola1

something that easily switches between the 2 different views

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