What I ended up doing is making 2 selects (select monthlybalance up to @EndDate and then another from @EndDate to @StartDate+11 for a full year) then union'd the data. Now I can use the original cross tab with this new table and fields.