I have a dashboard setup with slicers linking to multiple pivot tables, all using the same cache. I am trying to do some calculations to determine what the %difference of specimen volume is on the current week selected, considering i have a data column called "Fiscal Week", to the average of past the 12 weeks. Therefore, week 15 would need to be compared to the average specimen volume from weeks 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, and 14, but week 3 would only need to be compared to weeks 1 and 2 since that's the beginning of the data. So, what code can i use to make the pivot table change to filter for these weeks only?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Change PivotTable selection to multiple criteria based on table value
- Thread starter RaydenUK
- Start date
-
- Tags
- cache difference pivot table slicer vba
Similar threads
- Question
