Forum Discussion
Rank Customers Sales by Location
Hello Good people, I have read quite a lot of questions/posts of similialr to scenario and couldnt' get the answer. My case is as per below, I have a table which includes client, contract lo...
amitchandak Thanks !
I have managed to rank with the first formalar as shown in my qestions. I have to rank also based on the contract location for that selected customer. Your suggestion only gives us the same rank.. see below
For the selected customer, we will like to
1. Rank based on their contracts location 's ITO(sales)
2. View how many customers are there within that contracts location
3. Total ITO(Sales) for each available contract location for the selected customer.
Thanks