I'd talk to the folks that are responsible for the script that adds the column each day to give me another column [row_total] that would add all previous columns. If they do it using DynamicCrossTab it'll be an easy task for them to do. 😉
To get the column totals use sum() or, if needed together with the row results, look into WITH ROLLUP operator.
If you need more info than that, please read the first link in my signature (it'll link you to the same article Gail has been pointing at...)