Reporting on Pipeline Created

I've been tasked with reporting on MT Pipeline Created but I noticed that the Program Analyzer only allows me to sort by DATA of program, NOT by date of opportunity.

In a perfect world I would be able to look at the last 6 months and identify the MT pipeline created by marketing programs in that same time-frame.

Currently I'm only able to report on MT pipeline created by programs which have been created in the last 6 months, which is a useful but different metric then I'm looking for.

Note: I don't have RCA........yet

Any help or clarification appreciated!