So they want a report that says something like:
EXPENSES
Account#: 50112
Account#: 503149
Account#: 800100
SALES
Account#: XYZ
Account#: ABC
YADA
You can use the existing data, create a formula field to "Name" each account # into a group using the exact same criteria you used for the grouping you did formulatically
Like
if table.account#field="800100" or table.account#field like "50*" then "EXPENSES" else if table.account#field="ABC" then "SALES" else if ...
From there Create a group on this formula field
then if you want create a second group on the Account# and suppress and details if needed (to remove duplications based on your data)
Is this what you are looking for?
IP Logged
