2 Replies Latest reply on Mar 23, 2016 11:06 PM by Tableau kumar

    Show Top and Bottom values using Sets

    Jose Silva

      Hi, I am trying to show the top and bottom products according to sales, but the problems is, when I try to do this by sets it seems that the values I obtained are wrong.

       

      Obtaining the Top N products is easy, just using a Rank and filtering this to show the top 5 (For example), but when I do this using "sets" the result it does not show the correct ranking. What am I doing wrong?, can somebody help me please?. I would like to find the bottom values as well, but I do not trust in this method anymore.

       

      Top 5 using Rank

      Top 5 by Rank.png

       

      Top 5 using "Sets", there it can be seen that the values are different

      Top 5 using sets.png