Filtering of Selected Elements

You can filter those elements which you’ve selected on the tab “Selection”. There is a second tab “Filter” which is used for this.

Let us make an example: let us choose all mountain bikes which are in the top 10 by the sum of sales in the first quarter of 2017. In order to select them, please do the following.

Choose all bicycles:

Create a new filtering group on the tab “Filter”:

Fill in the data in order to select top 10 as shown on the following picture:

In order to make so that the “Reseller Sales Amount” is to be computed using the 1^st quarter of 2017 (but not all the time) you have to override context: press the button “Override Context for Hierarchy…”

Choose the time hierarchy:

Choose the 1^st quarter of 2017:

After pressing «OK» you will get this:

Add one more filtering condition:

In order to filter only mountain bikes fill in the following form:

All filtering conditions are set. In order to make so that both conditions are applied to selected members, you have to select the “And” join type:

If you apply this filter, you will see the expected result:

In the first condition you applied filtering by measure. In the second – using a property.

When you’re filtering by measure value, you can select one of the following conditions:

The list of available conditions:

• Topmost members whose sum >= X% of the total;
• Smallest members whose sum >= X% of the total;
• Topmost members whose sum >= X;
• Smallest members whose sum >= X;
• Members with value = Х;
• Members with value <> Х;
• Members with value > Х;
• Members with value >= Х;
• Members with value < Х;
• Members with value <= Х;
• Members with value in the range from X to Y;
• Topmost X members;
• Smallest X members;

If you filter elements by property, the list of conditions depends on the type of the property: is it text, numeric or date.

If the property type is numeric or date, the list of conditions is identical to the list for measure.

If the property is of text type, the list of conditions is as following:

• Members with values satisfying mask (the mask is case insensitive; you can use symbol «*» in the beginning and in the end of the mask);
• Members with values =  Х;
• Members with values <> Х;
• Members with values > Х;
• Members with values >= Х;
• Members with values < Х;
• Members with values <= Х;
• Members with values in range between X and Y;
• Topmost X values;
• Smallest X values.

It is possible to change filter status: