The ultimate solution is to use Crystal Reports with Adagio SalesAnalysis. But what modules do you own? Depending on the list, there could be a cheaper, less elegant, way.

Also, can you attach a sample of the desired report, just a page or part of a page?

Steve