RANKING

[#1]

Hi,

Let's imagine we have two fields: Articles and Sales.

The objective is to create a Text Object that says the rank position of each Article (in terms of Sales), meaning that when we select the Article=A we want to see our text object saying:7 as is it shown into the right table. The current problem with the right table is that when we select one Article, the rank is always 1, no matter what article is selected.

Thank you in advance!

[maxgro · Accepted solution]

try

aggr(rank(sum({<Article=>} Ventas)), Article)

[ecolomer]

Is this you need?

[#4]

I've used set analysis in "Article" to ignore its selection.

Good luck!

[#5]

THANK YOU!