Filter calculated column based on drop-down expression

[Hesloan Viana]

Hi,

I have a drop-down called 'INDEVOLUCAOPROD' with 4 expressions for squad's: 'ALL', 'IAAS', 'SAAS', 'SECURITY', 'UC' and a PRODUCT_FILTER calculated column.

Each squad have their own products:

'IAAS' = 'A', 'B', 'C' products.

'SAAS' = 'D', 'E' products.

I have another drop-down called 'PRODUCTS' that must be filtered based on first drop-down that filter squad's (UC, SECURITY, SAAS,IAAS). The problem is for 'ALL' expression, i dont know how to show all products for all squad's.

The PRODUCT_FILTER calculated column is calculated using : if ([sQUAD] = "${INDEVOLUCAOPROD}",[PRODUTO], NULL) expression.

How can i show all products when my first drop-down have 'ALL' value