Ranking Data in Tables

[#1]

Hi everybody,

I have a question about ranking some data. I have every purchase from each client in my database, and I also have a column that tells me where (Store_ID) each customer made this purchase.

What I need is making a Ranking, by Store, that indicates wich position each customer has in each store (1st buyer, 2nd buyer, etc).

I made an example in Excel spreadsheet attached, to make it clear.

If you can help me with this issue, would be great.

Thanx.

Rodrigo

[#2 · Accepted solution]

Hi Rodirigo,

You could do this with the help of HRank(). You Expression would be as follows.

Hrank(sum(Data),0,1)

Check the attached application.

- Sridhar

[#3]

Thank you very much Sridhar, worked perfectly!

See ya...