Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show Field Values based on Conditions/Filters. I can use 'if', but the filters have to be manually selected in order for the values to be filtered. I need something like Set Analysis that doesn't change with other filters but show the values defined within the Expression.
if(FieldA='A', FieldB='B', FieldC)
In this case, the user needs to select 'A' in FieldA and 'B' in FieldB. I need the table to show only those values in FieldC that satisfies FieldA=A and FieldB=B all the time; something like Set Analysis but without Numeric Operators like Sum or Count?
Maybe
Only({1<FieldA={'A'},FieldB={'B'}>} FieldC)
If you have a data set someone can help easily...
1 <<< in Set Analysis would ignore any selections made in filter hence Field A or Field B would be static.
Perfect. The '1' identifier is all I was looking for. This disregards any other values except for those mentioned in the Expression. Thank you so much