# Aggregated variables

Aggregated variables allow you to analyse recency activity by right dragging a **Selector variable** onto a Cube dimension so that you can select, order and pick transactions to be used for the display.

## Create an aggregated variable dimension

In this example we will look to analyse People by the Last Destination they booked and the Last type of Insurance Cover they have taken.

1. Display a Cube on a blank Selection window both set to the People table level
2. Right drag the **Destination** variable onto the vertical dimension of the Cube
3. Select the **Add First/Last Destination** option from the pop up menu

   On the window that appears you can choose which activity you want by defining its position and a method by which it's ordered. You may also filter the records that are examined by applying a selection query.
4. Select the **Last 1 Booking** and then drag **Booking Date** onto the ordered by box
5. Click **OK**

   Repeat this process with Insurance Cover on the horizontal dimension.
6. Right drag the **Cover** variable onto the horizontal dimension of the Cube
7. Select the **Add First/Last Destination** option from the pop up menu
8. Select the **Last 1 Insurance** and then drag **Policy Date** onto the ordered by box
9. Click **OK**
10. To now analyse these results, click the **Build** button on the Cube

We can now see that 14,324 People booked their last holiday to France and also last took out Family Insurance Cover.

> [!NOTE]
>
> You can use the same variable on each of the dimensions e.g. Last booking to France and First booking to Germany.