Summary+Fields+Solution+Part+1

Part 1
Produce a report layout which shows total number of tickets sales for each city.

1. In Define Database, create a new Summary Field called TotalTickets. This should be a total of TicketsSold

2. Create a new layout (no body)

3. Add New Part -> Sub Summary sorted by VenueCity(Trailing)

4. Add VenueCity and TotalTickets to this part

5. Ensure records are sorted by: VenueCity

6. Click Preview Mode