Forum Discussion

_chris_'s avatar
_chris_
Helper III
7 years ago
Solved

Filtering in visual element?

Hi, i have a table with columns delta and amount. I want to show only the Top 5 rows ordered by amount desc but only where delta>20. Is there a way to directly achieve this in the visual element (tab...
  • MFelix's avatar
    MFelix
    7 years ago

    Hi _chris_,

     

    Did not understand that part of the question, go to the Delta column and filter all that are above 20 even if delta is not part of your visual table you can filter the table taking that into account.

     

    In the example below I only have 4 deltas above 20 so the list is not giving me the top 5 but 4.

     

     

    This is making a simple use of the tool, you can also create some measure to make this to work, but believe that this simple soluition is better for begining to understand the filters options you have.

     

    Regards,

    MFelix