Summary+Fields+Solution+Part+2

Part 2
Produce a report layout which shows the total ticket sales revenue for each city (formatted as currency)

1. In Define Database, create a new Calculation Field called TotalRevenue. This should be calculated as: =TicketsSold*CostPerTicket

2. Create a new layout (no body)

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

4. Add VenueCity and TotalRevenue to this part

5. Ensure records are sorted by: VenueCity

6. Click Preview Mode