Enable selections\filtering on a field that is used in set analysis

[Anonymous]

Hi All,

I have a requirement to be able to filter a straight table even though the field is being used in set analysis.

IE

PRODUCTS are:

CHEESE SPREAD

JAM

MARGERINE

PEANUT BUTTER

I am displaying all products in a straight table that contain the letter "e" in set analysis with this expression:

sum({<PRODUCT={'*E*'}>}SALE_PRICE)

How can i change the above exp to allow me to be able to select CHEESE SPREAD for instance, from a listbox and the straight table should filter for this product only?

I.e

the straight table in the blue area should filter like how the table on left filters ...

[sunny_talwar · Accepted solution]

Try this:

Sum({<PRODUCT *= {'*E*'}>}QTY)

[sunny_talwar]

Learn about the operators here:

Implicit Set Operators

[Anonymous]

Thanks Sunny!!