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