Is it not an option to alter the source data to create a "transation" style data source?
Date Type Date $M
Order Accepted March 12 .004
Opportunities Bid March 12 6.142
Orders Accepted April 12 .632
Opportunities Bid April 12 1.048
Just a thought,
Did this resolve your question?
Ugh. What a waste of time.