Ranking Suppliers

[dmac1971]

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?

[maleksafa]

can you share a sample document?

[dmac1971]

Sorry wont be able to do this, but I'm sure someone else will have done something similar in the past.

[#4]

Hi Dermot,

If you just need a simple table to view this data,then you can use Table chart where you can sort and use the count function in expression along with the Avg price field.

Regards,

Barathiraja

[dmac1971]

See attached sample QV document.  This shows a list of parts each of which can have up to 10 suppliers.

I'd like to be able to show the following :

Item No	Supplier 1	Qty	Avg Price	Supplier 2	Qty	Avg Price	Supplier 3	Qty	Avg Price

[juraj_misina]

I didn't manage to get it into one row per [Item] (FirstSortedValue() returns Null() if more values share the first rank, Rank() trials only worked for the first Vendor/Qty/Avg Price). But maybe this solution using dimension limits will suit you.