Forum Discussion

efebo's avatar
efebo
Frequent Visitor
5 years ago
Solved

How can I exclude data from a table using a filter?

 

How can I exclude data from a table using a filter?

Hi,

 

Please, I need some help.

 

I have a custom SPO list to manage company risks. This list has a calculated column that uses data from other columns to set a KPI: green (1), yellow (2), and red (0). By default, KPI is yellow (2). Now I need to display items only red KPI, everything else MUST be excluded. Users only want to see items that require their action/attention.

 

 

How can I do that? 

 

Thanks in advance.

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi efebo 

    In the filter pane select your measure and and type Red