Group within a group

[cognosehelp01]

Hey guys,

So I am trying to group the amount of employees a manager has, and I am doing a group on the manager.  There is a one manager that shows up under three different manager IDs and I was wondering if I could group these three IDs together so that all his totals add all three?

[adam_mc]

Have you tried creating a calculation based on Manager ID that consolidates these together, then use this column to group together.

Something like:  if ([Manager ID] in (1,2,3)) then ('John Smith') else ([Manager Name])

Hope this helps!
Adam.

[Lynn]

Hey guys,

So I am trying to group the amount of employees a manager has, and I am doing a group on the manager.  There is a one manager that shows up under three different manager IDs and I was wondering if I could group these three IDs together so that all his totals add all three?

Relational or Dimensional? The answer could vary depending on which type of source you have.

[cognosehelp01]

It was relational, and Adam's answer was exactly what I was looking for, thank you!