Help with a Percentage formula's in group footers 1

[cyreports]

In my report, I have 3 Grouping Levels:

Group 1 - ApptDate
Group 2 - Resource
Group 3 - Financial Class

In each group footer, I am doing a Distinct Count of AppointmentId. What I need to do is calculate percentages and unsure how. In my Group 2 footer, I would like to have the percentage based off the Group 1 total. In my Group 3 footer, I would need the % based of the Group 2 total. In my Group 1 Footer, I would need the percentage based off the Total Distinct count. Does this make sense? Any help is appreciated.

 

[lbass]

//Grp3 footer:
distinctcount({table.apptID},{table.finclass})%distinctcount({table.apptID},{table.resource})

//Grp2 footer:
distinctcount({table.apptID},{table.resource})%distinctcount({table.apptID},{table.apptdate})

//Grp1 footer:
distinctcount({table.apptID},{table.apptdate})%distinctcount({table.apptID})

-LB