Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try e() in set analysis,
try like
=SUM({<groupName=e(groupName),INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)
Regards,
Try expression as,
If(Getselectedcount(groupName)=0, SUM({<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity), SUM({1-$<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)
Hi,
Try e() in set analysis,
try like
=SUM({<groupName=e(groupName),INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)
Regards,