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?
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.
Quote from: cognosehelp01 on 16 Oct 2014 02:39:54 PM
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.
It was relational, and Adam's answer was exactly what I was looking for, thank you!