Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a situation where I have a manager hierarchy and I want to get employee totals for each level, but I want 1 column per manager (be it the manager a top level manager, or a lowest level manager). I'm attaching an example, please note, in the example, I have a 'City' field (this is only an example but I want to demonstrate with this that I have multiple dimensional values like city that users can select, so I don't see a good way of building a table in the script with the counts of each level, because then the filters wouldn't work). Here is what I can get using a pivot table:
But what I really want is:
Thank you for any help you can give me!
Josh
Add a new table in the script like this
Dim:
LOAD * INLINE [
Dim
1
2
3
];
and now create a chart with these
Dimension
=Pick(Dim, Mgr1, Mgr2, Mgr3)
Expression
=sum(TotalEmp)
Add a new table in the script like this
Dim:
LOAD * INLINE [
Dim
1
2
3
];
and now create a chart with these
Dimension
=Pick(Dim, Mgr1, Mgr2, Mgr3)
Expression
=sum(TotalEmp)
Yes, that is perfect. Thank you!