Hi Dharmendra Ojha,
Have you tried this?
- Create a separate worksheet for each level (listing only employees at that level)
- Use action filters on a dashboard that target Select Fields, selecting Employee from the source sheet and the appropriate Mrg Level on the target sheet.
- Use the instructions in Dynamically Hiding a Sheet from the Dashboard to collapse the crosstab unless they are selected.
Also, this documentation is pretty handy: Dynamic Hierarchies with Tableau
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see an Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Thanks for reply.
I have tried using step 1 and 2 but it doesn't work. as I have single target column in details when I set action for all column in summary it considers only the last one in sequence. rest doesn't perform any action.