1 Reply Latest reply on Apr 11, 2018 10:38 AM by Matt Lutton

    Above and Below average filters

    Andrei Bulichi

      Hello ,

       

      I want to create some calculations to have a selection option " Above and Below" average for a 5 different measures.

       

      I've created a calculation for one of the measures. What I'm struggle here is how to filter the values/ companies above / below yellow line.

       

      I've attached a ample for this.

       

      I appreciate any help.

       

      Thank you.

        • 1. Re: Above and Below average filters
          Matt Lutton

          It would be easier to do one measure at a time, for certain -- could you then use a parameter to swap out the measure/average being used?  Just wanting to make sure I understand the requirement before trying anything -- for one measure, I believe it would be easy to accomplish, but I'm not 100% sure about doing this with multiple measures sharing an axis in the view.

           

          Happy analyzing and best wishes!