There is an intent to expand on all of Sesame's reporting capabilities, including the addition of cross-tab capabilities. However, cross tab is not likely to be available in "the very near future".

Sesame does have multiple export formats and Sesame reports are produced as HTML. Either of these formats can be easily pulled into Excel as raw data, which loves to do pivot tables. I've done some very nice automation for clients who need to produce Excel spreadsheets to be emailed to clients using Sesame's @Shell command and Excel VBA to extract data from Sesame, feed it to Excel, and process it as needed.

In addition, the Extractor utility can pull data live from a Sesame database, if you want to do the whole process from inside Excel.

However, this may not work for you with that kind of volume, as Excel cannot manage more than 65536 rows.

For your particular requirements, you may want to look for a package that is more tightly focused on high-volume statistical analysis. Sesame is a generalized database management system which offers a number of data entry oriented capabilities that you may not need, since you pull your data in raw bulk.