2 Replies Latest reply on May 7, 2018 11:13 PM by koushik.neelakantha

    Top/Bottom in a single sheet

    koushik.neelakantha

      Hello everyone, Please find the attached workbook. I have used rank function to display Top/bottom 10 values.

       

      Please find the below logic:

       

      IF [TOP/BOTTOM]='TOP10' THEN RANK(SUM([Sales]),'DESC')<11

      ELSEIF [TOP/BOTTOM]='BOTTOM10' THEN RANK(SUM([Sales]),'ASC')<11

      END

       

      When i select top10 from parameter i am getting desired output, but when i try to select bottom 10, Graph is not getting changed.

       

      Dragged RANK calc field into filter shelf and selected true. Please help me out.

       

      Regards,

      Koushik.