Forum Discussion
Visualizing data slicer with layered data (i.e. parent/child relationships)
Hi Devildogtevor,
Scenario:
John and Jane employee report to Mike supervisor
Jack and Jill employee report to Sally supervisor
Mike and Sally report to Steve manager
I'm still a little confused about your sceanrio.
If it is convenient, could you share some data sample which could reproduce your scenario so that I can understand it better and help further on it.
Best Regards,
Cherry
Below is an org chart with some sample data.
The first issue I have is when I select my Slicer 1 (report to) on Sally, I get the expense amount only of 120 (Jack and Jills expenses) but I want it to include Sallys too, so the amount returned should be 620 (the slicer selection and their direct reports).
The second issue is when I select my Slicer 1 (report to) on Steve, I get the expense amount of 500 (Sallys expense only as Mike has none), none of the layers below the direct reports are included. As such, I want it to include himself (problem 1) and ALL the layers below him in the org chart (problem 2) so it should be 1270, the direct reports and all the subordinate layers.
I hope I explained that well enough, I am sure this is an easy BI task, I just havent figured it out yet.