Skip to main content
Question

How to Show Top 5 Vendors without Others?

  • April 6, 2023
  • 2 replies
  • 32 views
K
Level 2

I want to show a graph with 5 Top Vendors according to the value (which is the sum of complex calculation values with few cases embedded). I am good with using First K Rows. However I do not want to show "Others" as it destroys the view, as "Others" has much bigger values than individual Top 5.

 

Is there any way to actually show Top 5 without others?

Will be grateful for any answers

 

Best regards,

Krzysztof

    2 replies

    F
    Level 2
    Forum|alt.badge.img+5
    • frank.marte
    • Level 2
    • April 6, 2023

    Why are you filtering on First K Rows and not Limit and them Maximum elements shown = 5

     

    K
    Level 2

    Mostly because I am still considering OLAP Table and do not want to enable sorting to users. However in the chart I will not have this problem. I guess the Limit is actually the best solution here. Thank you for your answer!

    Community Code of ConductAccessibility statement