I am fairly New to QlikView and have run into a headscratcher. I need to be able to tell how many hours a resource has worked for their manager. I have a table that has their org structure, resource name, time period and hours worked.
I need to be able to create a drill down from Bob down to each Resource
All resources that work for BOB have worked 124
All Resources that work for Jane have worked 72
All Resources that work for James have worked 72
All Resouces that work for Early have worked 20
All Resources that work for Candance have worked for 32
The problem I am running into is what to do with Jeanne since she has worked for two managers I need to show those two different org structures. If I key off Jeanne than James and early both get 92 hrs, I think I have to split the org structure into a resource manager table but I am stuck any Ideas?