Using a filter with on activate sheet trigger

[zagzebski]

I am trying to filter some data based on the activation of a sheet (using a trigger)

Right now I have a bunch of expressions that look similar to this:

Sum({$<MajorCategory={'Operating Expense'},FilterUser={'$(=OSUser())'}>} Net)

I want to get able to take this section: FilterUser={'$(=OSUser())'} of the expression and use it to filter the data upon activation of the sheet. Is this possible? This part of the set analysis filters on the user's data so I have to put it into every expression if I don't figure out a way to get it at the sheet level. (Note: I realize this is like section access but for different reasons section access is not the best route)

Thanks in advance.

[zagzebski]

Awesome! I have to do a little more testing but I think this is exactly what I need!

Thanks so much!

[felipe_dutra]