Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you very much Sridhar, worked perfectly!
See ya...