This example is the one described in the previous section. We can set this up in the interface using the choices in the screenshot below.
Table with details in
A couple of example people cyprus mobile number example are shown below. The highlighted transactions are those to their highest-spend destination. We can see that for the second person their one holiday to Portugal has cost more than the total of the two holidays to Greece.
Tables with information
If instead of choosing the Sum(Cost) to each Destination we had chosen the Frequency(Bookings) as our function to apply at the first stage, then the 2nd person would have had a value of 2 – as represented by their two holidays to Greece.
Let’s look at some other examples of functions that we can apply to those group results. In all of these examples we will use Destination as our grouping variable and the Sum(Cost) function to work out the value associated with each group.