insert the pivot into a temp table first, then select from that with you roll-up totals.