Hello Excel Gurus,
I'm working on a difficult problem that I believe will require a macros, but I'm not sure. I'm creating a dashboard using powerpivot and I have two sets of data that I would like to toggle between, Raw Data (15 columns) and Scores Based off of Raw Data (10 columns). I would like to add it so that I can just toggle between the two using a slicer, but other than adding all the columns to a hierarchy, which would look pretty sloppy, I'm not sure how to do this.
Does anyone have any tips for me?
Bookmarks