Hi I'm trying to create a dashboard that uses the same worksheet twice but allows user to use different filters on each worksheet. I tried creating a duplicate (also tried copy/paste) worksheet and then changing the filter on the new worksheet. However, all changes on the duplicate would change the original.
I want to do this so that on my dashboard I can simultaneously see # of items sold on one worksheet and then also $ of sales sold on copied worksheet, with everything else being equal.
How can I show this?
Have you applied filters as "All Using this Datasource"?