8 Replies Latest reply: Nov 30, 2011 7:39 AM by sandeepa rout RSS

    Ranking

    sandeepa rout

      Hi All,

       

      I would like to ask you how can I populate Top 5, Top 10, Top 20, Top 30 till  Top 100 Customers and Products.

       

      I have sort the amount in descending and in presentation tab I have checked Max 100. In this way I can able to show 100 top customers. But I also have to show top 10, 20, 30... so on till 100.

       

      Thanks.

        • Ranking
          Stefan Wühl

          Hi,

           

          if you want to rank e.g. by sum(Sales), you could use a calculated dimension like

           

          =aggr(if(rank(sum(Sales))<=5,Customer), Customer)

           

          and expression

          =sum(Sales)

           

          Replace Customer with Products if needed and 5 with 10, 20,30 , 100.

           

          Hope this helps,

          Stefan

            • Re: Ranking
              sandeepa rout

              Hi,

               

              Thanks for the quick response.

               

              But then i have to change it always. Is there any alternative ways..?

               

              Thanks.

                • Re: Ranking
                  Stefan Wühl

                  Not really sure what you are after,

                   

                  you could use a variable with associated slider to change the X in TopX instead of hardcoding the X.

                   

                  Or you could highlight the different X by color, something like this as background color expression in expression tab:

                   

                  =if(rank(sum(Sales))<=5,green()

                       if(rank(sum(Sales))<=10, yellow(), red() ) )

                   

                  (This are awful colors, just an example).

                   

                  If you tell us a bit more detailed, what you are looking for, we can help you better.

                   

                  Regards,

                  Stefan