1 Reply Latest reply on Nov 13, 2013 6:36 PM by Kyle Pipkins

    Dynamic "others" grouping?

    John Bencina

      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:

      list.gif

      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.