Hello,
So I have two tabs on a report right now, one that looks at the 12 focus accounts of my organization and another that looks at everything else.
I want to consolidate these onto one tab however the way that I have these pages currently set up is with a page filter that either includes just those 12 accounts (based off of having them selected by name) or excludes those 12 acccounts (i.e. is not account x, y, and z). The reason that I have these pages set up like this is due to the fact that there is no field in my database denoting what is and is not a focus account.
Is there a way for me to create a button where if selected it would auto apply the 12 focus account filter and vice versa? Essentially a custom filter that I can name focus or other accounts and pending which side is clicked it applies the right filter? I searched online for this for quite a while but wasn't able to come up with anything. I am hesitant to create a static table which denotes these accounts as they can change at the drop of a hat and adjusting the filters is much easier. Thanks in advance for your help.
