I have a table with 2 event types and I need to create subtotals at the bottom of the report for each event type and then the total overall events
I have a table that has 2 event types - let's call them event A and Events B. Some of Event's A and B are events that are reoccurring - so they are at the same venue monthly for example - and each should be counted as a separate event. I currently have a report that sorts and groups the events on the event name so the user can see what events are reoccurring and how many they have. It currently has a total at the bottom totaling the number of Event A's and B's. in addition to the overall total, the user would like to know subtotals of event A's separate from event B's. Can I add this to one report or do I need to do a separate one?