### Title

How to include the grand total in the subsummary calculation?

### Post

I'm trying to make a report that shows statistics.

For example: There are 1,000 students. Im trying to include the Total (1,000) in the sub-summary when breaking down the students into categories. So the report should look like the following:

State Students are from | Number of students | Ratio |

State A | 200 | 20% |

State B | 300 | 30% |

State C | 500 | 50% |

Total | 1,000 | 100% |

How do I get the Ratio column numbers?

I've tried all sorts of stuff with the States groupings in subsummaries, but the Ratios would all be 100% each or nothing.

Thanks for you help in advance.

GetSummary ( TotalNumberofStudents ; StateField ) / TotalNumberofStudents

Should work as long as your records are sorted by StateField.

You should also be able to define a "fraction of total" summary field that gives you the same results.