Pivot Tables in Reports 2.0 based Off Of SFDC Data

Related products: CS Reports & Dashboards

I am seeing a growing need for pivot reports built off of SFDC Data. It appears only MDA data can be pivoted on. 
I know pivot tables well and I still don't know how to use the pivot option in Reports 2.0!
Has this idea made gained any traction at all ?

Am trying to summarise various reports on eg Invoice Date from the SFDC Orders object by Month or Quarter and really dont want to be duplicating this information into an MDA object