Can we hide certain rows in a straight table based on an expression value?
Hello, community.
I have a straight table chart with many dimensions, shown or conditionaly hidden, and some expressions...
One of those expressions is of the form:
if(col(1)=1 and col(2)=1,'Yes','No').
What i want is to give my users the ability to select all the 'No' or all the 'Yes' rows of the chart in order to focus their analysis only in one specific segment of the data or easily extract them in Excel...
Have in my mind that i cannot move the calculation (if(col(1)=1 and col(2)=1,'Yes','No') ) in the LOAD script because the calculation must be dynamic according to the user input...
