This content has been marked as final. Show 2 replies
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 using "Sets", there it can be seen that the values are different