Showing results for 
Search instead for 
Did you mean: 
Sisense Team Member
Sisense Team Member

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.




Version history
Last update:
‎05-22-2024 08:50 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: