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

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.