Hi All,
I've spent some time searching for an easy way to extract the values of a report filter when multiple items have been selected on a pivot table and have been unable to find one. I'd like to use the values to label a chart with the relevant information from the filter selection. I've found lengthy macros that can do the job, but I'm looking for something simple. Does such a thing exist?
Thanks!
I've spent some time searching for an easy way to extract the values of a report filter when multiple items have been selected on a pivot table and have been unable to find one. I'd like to use the values to label a chart with the relevant information from the filter selection. I've found lengthy macros that can do the job, but I'm looking for something simple. Does such a thing exist?
Thanks!