Combining set analysis with Aggr

This recipe will show you how to use set analysis with aggregation functions combined with Aggr().

Set analysis modifies the behavior of the filters in an aggregation expression. When using Aggr(), you have two aggregations, one inside Aggr() and the other outside Aggr(), as in the following example:

= Max( Aggr(rank(Sum(Sales)), Country)) 

Where to insert the set analysis expression? Will the result be the same?

This recipe will show how the set analysis in the inner or the outer aggregation affects the result.

Getting ready

For this recipe, we will reuse the data load for the Using nested aggregation recipe from ealier in this chapter.

How to do it…

1. Drag a Table object.
2. Add the text, Europe Rank, as the object title.
3. Add a dimension: Country.
4. Uncheck the Include null values property.
5. Add a new measure with the following expression, with the Regional Rank label:

= Max( Aggr(rank(Sum( {<Region={'Europe'}>} Sales)), Country))

6. Add the second measure with the following...