Hiding Rows based on selection

[Anonymous]

Hi All

I have a requirement where I should hide rows from a straight table based on selection.

The values which are selected is Hide Row filter must be hidden from the table.

For example I have selected Coconut oil and Niacinamide. Both the values must be hidden from the table. But I am not able to hide. Only when a single selection is made in HideRow filter the row is hidden.

There are two dimensions Commodity Number and groupName which has alias name 'Ingredients'

The filter 'Hide Row' denotes groupName. groupName is given a alias name as 'Hide Row'.

The expression which i have used is

=SUM({<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)

where

vSelectedGroups = GetFieldSelections(groupName,',',20)

Can anyone help me on this.

Thanks

Koushik

[tamilarasu]

Try expression as,

If(Getselectedcount(groupName)=0,  SUM({<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity), SUM({1-$<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)

[PrashantSangle · Accepted solution]

Hi,

Try e() in set analysis,

try like

=SUM({<groupName=e(groupName),INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)

Regards,