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 !

       

      Elliott