Thank you so much for your reply and sincerely hope you don't mind if I ask you a follow-up question: what if I was trying to add a filter on "Measure Names", which is all building names in my case. So if I uncheck BL1, all info on BL1 would atomically disappear? I tried to right-click "Measure Names" above "Qtr" but there's no "All using related data sources" in there. Could you please help me? Thanks again for everything!
1 of 1 people found this helpful
Certain filters you can't do "apply to worksheets" with.
Table calcs is a common one.
Measure Names is another.