I need to retrieve sets of data from the same pivot, but under different filters. So far the best solution I've found is to copy that pivot 32 times through VBA for every segment I need. I.e. past 7 days, 7 days before that, 30 days, 30 days before that, and then "Mobile" and "PC" under "Device" filter for all those combinations. You can see how this might be considered inefficient. If I make all filters values instead, I can't reference the values I need directly, or even at all.
So to sum up, I need to GetPivotData but with specific filter settings. Is this possible?
Bookmarks