Hi everyone,
I have a requirement to to create a new column based on few things
For each client -> aggregation at this level
count status -> this can be either active or inactive but only we have to count active
and flag-> this can also be either 1,0
where column3<> 'sometext'
if count>0 then 'yes' else no
For each client, check count of active and flag linked to column3 where the column3 is not "sometext"
If the count > 0, then "Yes". Else, "No".
On front end only,