I have two visuals on two different pages of a report - both these pages use various page filters in addition to the "AM" or "PM" shift filter such that one page is specifically for morning shift and the other for evening shift.
Now I want to show a running "Week to date" total for the Weight on both the pages.
The complexity is that on the morning shift page it should show the running total of all previous days in the week AND the weight of the current "AM" shift.
And on the evening shift page it should show the running total of all previous days in the week including the current "PM" shift.
Both pages have selectable "DATE" slicer.
No filters on either page can be changed!! 😞
Please let me know how to calculate such a running weekly total. It works with a pivot table visual on a blank page, but as soon as I put it on one of these pages the result defaults to the daily total regardless of "Shift".