Calculating Totals from a category/group

[pbang007]

Hi,

I'm having trouble figuring out how to calculate totals for different categories. I've attached a photo to show some sample data. I need to get a separate total for the BC category and a separate total for AB category.

I have a feeling I'm missing something totally obvious.

Thanks in advance,

Peter

[ckai]

Just stumbled across this. If you haven't found the answer maybe this will help...

I'm assuming you just want to display the information in a report?

If you are, create a summary field in the right table, for the field you want to total and select that it restarts when sorted by your category.

Add this summary field to a report layout with the category in a sub-summary section and then sort the report based on category.

Good to go.