Hello,
we have been using a pivot table to create interval level data for a report. The user selects which historical weeks should be considered and what activates should be included in the pivot table options. is there a way to have the selected filters published in list form? Essentially, I was imagining a macro that would copy/past the selected interval distribution to a different tab, and then create a timestamp of when it published and what filters were used. Is there a macro that could report which options where listed on a given pivot table?
If not I'm wondering if I need to create a table that will do this instead of a pivot. However, I prefer to use this pivot if anyone out there has a suggestion. TIA!
we have been using a pivot table to create interval level data for a report. The user selects which historical weeks should be considered and what activates should be included in the pivot table options. is there a way to have the selected filters published in list form? Essentially, I was imagining a macro that would copy/past the selected interval distribution to a different tab, and then create a timestamp of when it published and what filters were used. Is there a macro that could report which options where listed on a given pivot table?
If not I'm wondering if I need to create a table that will do this instead of a pivot. However, I prefer to use this pivot if anyone out there has a suggestion. TIA!
