Totals and groups - how to calculate grand totals inside groupings

I have a report that has groupings that need to figure out the percentage of the grand total.

Example:

Group1
Count Total Count% Total%
100 1000 33.33% 25.00% <--detail
200 3000 66.67% 75.00% <--detail

Group 1 Totals
-- - -
300 4000 100.00% 100.00%

How do I code in the expression for the percentages when the totals needed for the calculation are in the footer?

in this case count/sum(count) but at the detail level

This should be simple right?

I know that in Crystal you can calculate inside a group by specifying...
count/groupname.sum(count) or the textboxvalue.
I tried the Count/ReportItems!CountTotal.value in SRS but no luck.
and if I try duing a separate query in a different dataset it takes too long to process because of the grouping.

[1120 byte] By [DragonVic] at [2007-12-25]