Is there a way to apply "Breaks" to multiple values to be together?

[former_member600156]

Hello,

Please refers to the following diagram that i created: https://imgur.com/a/U0idOlC

I am looking to apply "Breaks" to my report using 'Account #' column/object.

Now, when i do apply them, the report is broken down to every 'Account #' but i was looking to see if there is a way i can keep those records with 'Account #' as 1 and 2 to be separated together.

Is this possible? I played around with 'Group' and 'Break' for awhile but no luck so far.

Thank you

[Tom_N8 · Accepted solution]

Hi Edward,

Create a new dimension variable [Acct Grp] =If([Account #]InList("1";"2")) Then "1,2" Else [Account #], add it to your block. Apply a break on the new variable. Hide the column (if you want) via Hide > Hide Column. If you don't need your other accounts in the table block, filter these out with a table filter on the new variable.

Kind regards,

Tom