Apps Filter/Or condition to display table - LEGACY

Help Apps
, ,
1

Hi I’m trying to apply a filter condition on data service entity to get the count & also display two columns in a table in apps based on a 'OR ’ condition.

My sample table

Emp name Emp ID Status
A 120 Terminated
B 121 Locked
C 123 Active
D 124 Terminated

Now , I need to display the count of employees in either ‘Terminated’ or ‘Locked status’ in a text box in apps

Also I have to show in apps as

Status Count
Terminated 2
Locked 1

How do I do it ?
For count I manager to do a Sum(Count(filter(emp,[empstatus =‘terminated’]),count(filter(emp,[empstatus=‘locked’]))

But I want to use an OR statement with single filter with two conditions and how this data can be displayed in table?

2

In legacy OR condition is not supported for multiple filters .

Please switch to VB apps to do this .