Greetings! I am trying to track event registrations. My table has these fields:
Primary First Name
Primary Last Name
Event #1 Status (Single Select: Yes, No, Cancel, Didn’t Attend, Hasn’t Replied–applies to attendee coming alone or to attendee bringing a guest)
Event #1 Meal for Primary First (Single Select: Meat, Veg)
Guest First Name
Guest Last Name
Event #1 Meal for Primary Guest (Single Select: Meat, Veg)
How best to see a total sum of all the meat meals and all the veg meals?
Thank you–any assistance is greatly appreciated!