Expressions: Aggregations on the Fly - Frequency

Scenario:

What are the net numbers of bookings per person once bookings to the US have been removed?

• Click on the Add Aggregation button

• Click on the tab entitled Frequency(Communications)

  Note: The auto-naming feature will populate the Name box until you change it - see below.

• Leave Type as Frequency

• Set the Grouping Table to People and the Transactional Table to Bookings

• Create a selection that identifies Non US Bookings and drag it onto the filter box

  

• Change the Name to display Total Bookings excluding US

• Click the Build button to see a preview of the results

A Data Grid can be used to validate the results:

 

Click to return to Expressions: Aggregations on the Fly