5 Replies Latest reply on Nov 24, 2016 7:10 AM by Elliott Robin

    Making measure appear or disappear through hierarchy

    Elliott Robin

      Hi there,


      Here's the context:


      I have productivity rate for different levels of hierarchy in the enterprise, but I have a target for only one level and that target cannot be aggregated through other levels of hierarchy, cause the value won't make sense.


      Then, in the Image: the red line is the target (that comes from another source) and the productivity is blue. Actually I'm at department level and I wanna see the target at this level of hierarchy only. When I drill down to next level (or come back at higher level, I want the target to disappear.


      And I don't want a parameter that user will have to check to make the target appear or disappear.


      Thanks for your help


      Have a good day !