Say I wanted to group all my metrics that I have in my values in my pivot table(including all added calculated fields) into one field to be able to use in the Report Filter.
So I want all those values in a drop down to be able to select a metric and it populates my pivot table below.
Is that possible with VBA Code? Am I explaining clearly?
Edit Update -- Sample Attachment Below is what I'm looking for, only problem is that I have over 150 metrics that could change.
Bookmarks