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.
