I have a report that pulls in about 20 accounts. I need to create a custom grouping to separate these into two groups.
I am not sure how to do this. Each account has its own individual account code so I am trying to do something like this:
Group 1
Account 1
Account 2
Account 3
Group 1 totals

Group 2
Account 7
Account 9
Account 10
Group 2 totals

Each account has its own unique code.

So I was thinking something like.
If table.Accountcode in [111,122,113..] Then group 1
else
Group2

Just not sure how to implement that.

Bill

Too simple... Duh