I have a report that has a bunch of accounts on it (around 30). I need a way to automatically group certain accounts into "Others" while breaking out the rest.
My ideal functionality would be like this:
I have a list of accounts like this. I click the ones I want. The rest get put into "other". I can do this with a single account using a calculated field. But how would I feed it a list of multiple accounts?
What I basically need is a parameter control where I could say something like IF ACCOUNT NOT CHECKED THEN "OTHER" ELSE ACCOUNT
My other option is to manually rearrange the groupings which I'd like to avoid.
I don't know how to do what you're talking about, but if there is any type of a calculation that decides who the "others" are you can use the attached as a example of how to do that.