2 Replies Latest reply on Aug 19, 2019 12:12 PM by Philip Perrin

    FILTER

    Nolan Caprecho

      HI ALL,

       

      Just want to ask how to display the "Bottom (NO)" only even when you change the filters?

      I used RANK function to display their ranks and I want to display the Bottom 7 airports only. But im having trouble displaying the bottom 7 because I have different filters that changes the ranks at the bottom. If my filter is 'Domestic' the last 7 ranks would be 21-27 but when changed to international it changes to 29-35. So i need to change my slicer again. Is there a way that when I change my filter it would automatically display the bottom 7?

       

      THANKS

        • 1. Re: FILTER
          Philip Perrin

          Hi there Nolan -

          I think you need a context filter to accomplish this - let me do a quick test on some data, but I believe your bottom N filter, when added to context, will give you the results you are looking for.

          Phil

          • 2. Re: FILTER
            Philip Perrin

            Actually it is whatever else you are filtering on that needs to be added to context - not whatever you bottom N filter is. Post back if this works for you or if you still have questions!

            1 of 1 people found this helpful