Computed Group

[PhilMyWallet]

I have a report with 10 teams. Each team has different roles.
E.g

A01 = Sales
A02 = Marketing
A03 = Finance
A04 = Sales
A05 = Finance
A06 = Marketing
A07 = Sales
A08 = Sales
A09 = Marketing
A10 = Finance

How do I create a column (computed item) which will identify which group each team belongs to?

 

[iheartbrio]

You can create a group in the Results section by using the Decode function. Add a computed item, and then use a formula like this:

Decode ( Team, 'A01', 'Sales', 'A02', 'Marketing', 'A03', 'Finance', 'A04', 'Sales', 'A05', 'Finance', 'Other' )