Ranking

[omarlq20]

Srs podrian ayudarme a realizar este ranking debe estar ordenado por las dimensiones Tienda, Categoria, y Producto

Mrs, could help me with this ranking should be ordered by the dimensions Tienda, Categoria, y Producto

[swuehl]

Not quite sure what you expect as result, could you post the expected outcome?

Or maybe try this:

=rank(total sum(Stock))

[#3]

take the opportunity to consult a doubt with the example of the stores.

I need the ranking of the store that sold more, but omitting the other dimensions of the graph. This means, the store that sells more want a repeat of the one in each of their records.

Attache a Excel File with expected result.

[kumarnatarajan]

Hi,

Try This one

EX:  Aggr(NODISTINCT Rank(Sum(Stock)),Producto)

[#5]

Thanks Kumar.

In my example is

Aggr(NODISTINCT Rank(Sum(Stock)),Tienda)