Multiple Filtering

@rohandhondilalk Would you please be able to let us know the way you have tried so that we can suggest something(provided if there's a possibility) based on the same lines?

Iam adding the filters based on the group names.
Please find attachment for more details.

@rohandhondilalk What's the data type of the values hold by TeamName/TeamName1 etc?

User\\Group Name for both

@rohandhondilalk So, are they of type 'Text' or 'User or Group'? And can I assume they are single(i.e. non-multiple)?

@rohandhondilalk If the data type of the PV(or the value configured in the column) is 'User or Group', you may do as follows:

Add a new column(by name 'isTeamNameEqualsGroup1') which will have the following definition:

=fn!if(rule!APN_isBlank(pv!TeamName),fn!false(),fn!if(rule!APN_isBlank(fn!togroup(pv!TeamName)),fn!false(),fn!tointeger(fn!togroup(pv!TeamName))=cons!GROUP_1))

If the data type of the PV(or the value configured in the column) is 'Group', you may do as follows:

Add a new column(by name 'isTeamNameEqualsGroup1') which will have the following definition:

=fn!if(rule!APN_isBlank(pv!TeamName),fn!false(),fn!tointeger(fn!togroup(pv!TeamName))=cons!GROUP_1)

In the filters, add a new filter as follows: isTeamNameEqualsGroup1 = true.

If you want multiple conditions to be checked, configure the column with an array of conditional statements surrounded by fn!and() or fn!or().

If the data type of PV is Text, I am not sure how we can do it, as the Scripting Functions(mentioned at https://forum.appian.com/suite/help/16.3/Appian_Functions.html) won't work in Portal Reports. For instance, you might not be able to find a group by group name by using fn!getgroupbyname() or group name from group. So I believe it's better to maintain either a Group object or Group Id or User object or User Id rather than a Group Name, formatted User Name or a variable that holds Group Name or User Name.