Show in the Pivot Top 7 Values, Starting From the 3rd

Show in the Pivot Top 7 Values, Starting From the 3rd

We have a task to show from the top 10 values just from 3 through 10.

Based on Sample Ecommerce elasticube, we have in rows - "Brand" and in values "Total revenue"

To see just the Top 10 we will add a filter for Brand ranked by Total Revenue

 We add one more value on the widget - rank(sum([Revenue])) to rank all rows.

 
After this, we will create a filter based on this value, "Between 3 and 10"

 
As a result, we can see in the Pivot Top 7 Brands, from 3 to 10.

 
If you need to hide this third column, please check this article - Hide a column - Linux Pivot.