certain records will still show in the table even they don't meet the filter criteria specified by the users

[ronaldwang]

I need to build a table where holds records of products. and I will provide filter for user to filter on various attributes. but there is some records I wish to show in the table regardless whether it meets the criteria of those filters applied by the users. just wondering is there a way to achieve this

[Amit_Prajapati]

Hi @ronaldwang , To show in the table regardless whether it meets the criteria of those filters applied by the users you can By pass those fields in set analysis.

for ex.sum({<Year=,Month=>}expression) This will show the sales regardless selection of Year , Month.

Let me know if you are looking for something else.

[ronaldwang]

Hi Amit, thanks for the reply. what I try to achieve is actually as below where the filter is on Product type, when user select A or B, the result will show A&L or B&L, which means that product L will show regardless if the user has selected it.

[Nagaraju_KCS]

Try this 

Step1: Create a variable

=If(
WildMatch(GetFieldSelections([Product ID]), '*A*') OR WildMatch(GetFieldSelections([Product ID]), '*B*'),

Chr(123)&Chr(39) & GetFieldSelections([Product ID], Chr(39) & ',' & Chr(39), 100) & Chr(39) & ',' & Chr(39) & 'L' & Chr(39) & Chr(125),

Chr(123)&Chr(39) &GetFieldSelections([Product ID], Chr(39) & ',' & Chr(39), 100)&Chr(39)& Chr(125)
)

Step 2: Expression

IF(GetFieldSelections([Product ID])>0,
Only({<[Product ID] = $(vProduct)>} Product),
Only(Product))

[marcus_sommer]

Sets from a set analysis could be combined, for example with something in this direction:

sum({< [Product Type] = p([Product Type])> + < [Product Type] = {'L'}>} [Value])