5 Replies Latest reply: Dec 5, 2014 7:49 AM by Juraj Misina RSS

    Ranking Suppliers

    Dermot mcgoldrick

      Lets say I have a list of PO's, over 30,000, into the company for the last year, covering around 6500 parts.  Some of the parts have up to 4 suppliers and I want to quickly show no suppliers, COUNT(DISTINCT Vendor) and then show the average price for each of the vendors in a simple table.  What is the best way to go about this.  I've been looking at FirstSortedValue, and ranking but haven't figured it out yet?  Any ideas?