Format Rule: Top N / Bottom N

The “Top-Bottom” format conditions allow you to highlight a specific number of topmost/bottommost values. You can specify this number as an absolute or percent value:

For example, let us select 4 quarters for which the “Sales Amount” measure values were the worst. Select the type of “Bottom N” highlight and fill out the form as follows:

Pivot will look like this:

Now let us check those product categories, the profit from which amounted to 90% of the total profit. For this, select the “Top N” highlight type and fill out the form as follows:

We get the following Pivot:

Two product categories – “Bikes” and “Components” – gave 90% out of all profits.