This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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.
