Reading your question. the first thing which springs to mind is a cross-join.
That will create a larger data set whereby each order has all products and vice versa.
If i can find any time, I'll try and mock something up for you... but don't wait on me!
Best of luck
Thanks, it got me exactly where i needed to be! The only one thing that could be better, is i can only select one product from the parameter control, however i would like to be able to select more than one product so that it shows an overview, any ideas?