cancel
Showing results for 
Search instead for 
Did you mean: 
OleksandrB
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"

Screenshot_16.png


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

Screenshot_17.png


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

Screenshot_18.png

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

Screenshot_19.png

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

Screenshot_20.png

 
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: