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

[efebo]

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.

[aj1973 · Accepted solution]

Hi @efebo 

In the filter pane select your measure and and type Red

[efebo]

Thanks 😉