2 Replies Latest reply: Nov 7, 2011 1:15 PM by Ms. Shrestha RSS

    Rank function

      Hello All,

       

      I am running into an issue when using the Rank function.

       

      Requirement:  To design a chart that will show  ITEMS where Rank Sales and Rank Volume <=5.

      Below image is the chart return from

       

      DIMENTION: ITEM

      TWO EXPRESSION :

                RANK (SUM (SALES))

                RANK(SUM(VOLUME))

       

      Question : How do i eliminate , ITEM G highlighted in yellow from appearing on the chart.

       

      Any suggestions will be appreciated.

       

      Thank you.

      Pranita

       

      RANK ISSUE.png