Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hierarchy Filter Selection

Hi,   In my dataset, Program belongs to school and School belongs to the Centre. For example, Centre 2 has 4 Schools under it and they offer together 33 programs and School 2, one of the schools of...
Need Help
Tips and Tricks
Tutorial Requests
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

If i am not mistaken, it is because you are using the ALLEXCEPT function.

Try adding School name and program name on your allexcept

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi mussaenda ,

     

    I tried it but does not resolve the issue. It works for the center but when I click school slicer, it does not work. 

     

    If I click a school from the slicer, I want to see only detail of that school and detail of related center. Similarly, if I click a program from Program slicer, I want to see details of relates school and center besides that program.

     

     

    School level does not workProgram level does not workCenter level work

     

    The link to file is here