IBM Business Analytics

Hi i've got a report with accounts grouped in various ways.  i'd like to group some accounts into a single line, while leaving the others ungrouped.  Is there a way to dictate which accounts are grouped and which are not?  thanks!

Create a new data item and use a case to show it in what ever way you need to group the accounts. Its pretty straight forward unless I've misunderstood your requirement..

case

when [Account] in ('A','B','C') then 'Group 1'

when [Account] in ('D','F') then 'Group 2' else [Account]

end