Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I need some major help so any advice would be greatly appreciated.
I have two tables: Orders & Cost. The orders table has a specified number of orders for a product from a specific source to a specific destination. The cost table has a 5 different options of possible sources for a specific location.
What I need to be able to do: I want a table or chart that shows me the product, source, destination with the three cheapest sources with their associated costs.... without actually showing each "options" from the cost table...
Any ideas?
Can you provide sample data?
Hello
As this is quite complex, some example data would be a big help in determining suggestions for an answer?
Please see attachment. It is sample data and it shows how I would like it to look like.
Any ideas?
Hey,
Please see file attached.
Regards
R
The problem is that I have over 100's of products..........so that would make this a little difficult
Check if fits your needs