Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to Calculate in Rank in Back end Scripting for the Getting the TOP 10 Customers...
Kindly help me on this...
Regards,
Helen
In the spreadsheet, the maximum order date is 12/29/2009.
Sample data i have shared, u can Fix the Last 12 Months Data & Bring the Top 10 Customers
Regards,
Helen
Ok. I don't think you need to handle this in the back-end at all.
I did everything in the front-end:
Total Sales within last 12 Months:
And Ranking in another column:
This is how I would do it, maybe someone else has a different approach. You can also combine the ranking part within a set analysis to only return top 10 customers.
Hope this helps
HI hbetty2012
Is there any specific reason to do it from back end?
Yes..
Because I need to bring it from Top 15 Stockists based on Last 12 Months Sales..
For Example: Current Month is --Oct-2015
Top 15 Stockists --Oct-2014 to Sep-2015
Bifurcation i need to Show as MTD Sales..If any of the 15 Stockists not having the Sales Value in all the MTD Months wise bifurcation that particular stockist is Missing because that particular stockist not having Sales, but Still i need to Show that particular Stockist with Sales Value as 0 in the MTD wise bifurcation..
Regards,
Helen