Cross Tab Report need summary and detail

Hi, I am using cross tab to generate an open sales report. the required dates are the columns and the report looks very good except for i need to summarize the qty late but keep the qty that is due in the future. because i have not been able to do this, my report is approx 60 pages long. if i only use the current date out to the last sale date the report is only 10 pages long. I beleive i need some sort of formula but i am clueless on how to do this. any help would be greatly appreciated.