I have a Workbook containing multiple sheets depicting the same time range in months.
Given that all time points on the view (all the months) show measures based on calculations dependent on previous months (thus also some which are not in the view), I applied a Table Calculation as a Filter, as opposed to Filtering the Dates (I did this to distort the values).
This is my filter:
My question is: How can I apply this filter to all Sheets, so I don't have to manually update every single sheet every time the time range is updated?
If I could apply it to all, then I could change a single one of these filters affecting all other sheets as well.
Any help is greatly, greatly appreciated!!
Unfortunately table calcs are worksheet specific because they rely on what's in the viz to work. So actually you cannot apply a table calculation filter on multiple sheets, it can only apply to the current sheet it is on.