Hi,
I have a people data table, formatted with the following data
Person, Grade, Manager
Person and Manager are simple text fields, so an entry might be
John Doe, D, Rick Smith
Rick Smith, C, Julie Anon
etc
In a table that shows the users, i would like a count measure of the number of people who report to a manager, for example, in Rick Smith's entry, i would like the "Direct Reports" field to contain the total number of people who have "Rick Smith" in their manager field.
Would appreciate some help achieving this.
To expand on this with a bit more complexity, if i wanted a further field called "Total Resource" that totalled up all of the "Direct Reports" measure would that be possible, e.g
If Manager 1 had 3 direct reports with Manger 1's name in the manager field. and Manager 2 had 5 director reports with Manager 2's name in the manager field, and then Manager 3 was listed as the manager of manager 1 and 2, i would like th total to in the "total resource" field to be 10 (3 for 1, 5 for 2, plus 1 and 2 themselves).
Hope that makes sense, can someone recommend a good book for learning qlik formulas like the ones required for above ?
