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?