Ranking: Suppliers by total spend?

gilgorev · June 27, 2011 9:47AM

I'm trying to create a filter that will allow me to show only the top X (say 50) suppliers in an invoices database. Any ideas how?

A good example would be to look at the Visokio example on http://www.visokio.com/kb/subset-functions-2-5:
How do I add a column to it that will show the number 1 against John Swires and 2 against Anne Campbell, reflecting their ranking in terms of total spend?

Thanks!

Gil

walsh · June 27, 2011 10:08AM

I had a similar problem and found this thread extremely helpful. I think it does what you want it to do. I used a slider tool to allow the user to modify the value of X in the "top X" categories, which was quite a nice feature.

gilgorev · June 27, 2011 10:23AM

Hi Walsh
Thanks for the quick reply! I've had a look and it looks very promising. The main problem is that I don't have the RUNNINGTOTAL formula on my version (2.5) is it an upgrade in 2.6?
Thanks
Gil

gilgorev · June 27, 2011 10:50AM

Thanks Walsh, worked very well! The only problem was that, not having version 2.6, I had to create the index in Excel - which took a few seconds so no major harm there. I guess an idea for the future would be to enable ranking by dynamic aggregation and by absolute (unfiltered) aggregation. If I can think of a way to do it I will be sure to share it ASAP

tjbate · June 27, 2011 11:02AM

Gil - you should be running 2.6 at KPMG. The download link is here:

http://www.visokio.com/okavango

gilgorev · June 27, 2011 11:29AM

Thanks, can I just check what do you mean by 'should'? Have we got a company licence?

Welcome!

Categories

Ideas Parade

Tagged