Adding a toggle to a pivot table

[raquelbuzz65]

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

[#2]

@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?

[#3]

@raquelbuzz65 

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

[#4]

@Abiola1 

something that easily switches between the 2 different views 

[#5]

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

[#6]

@raquelbuzz65 

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