Crosstab almost perfect

[Blair]

This is my sql

My crosstab has a total across the top, the total decreases as the count
goes up in the column rows. I would like a sub total at the bottom that
totals the columns and then a Grand total under that to total the number of
nests started with.
Hope I explained it right.
Lets say shed 1 has a start total at the top of 100 nests
as each day passes some nests are added to the column and subtracted from
the 100 at the top so the top total keeps decreasing, but there are no
totals at the bottom to give me the total of all the days and the grand
total which in this case would always total 100.

Thanks any help
Blair

TRANSFORM Count(QDailyWheplingReport2.[NEST #]) AS [The Value]
SELECT QDailyWheplingReport2.[WHELPING DATE],
Count(QDailyWheplingReport2.[NEST #]) AS [Total Of NEST #]
FROM QDailyWheplingReport2
GROUP BY QDailyWheplingReport2.[WHELPING DATE]
PIVOT QDailyWheplingReport2.[SHED #];