I suspect I'm making this more difficult than it needs to be, but I'm stuck at the moment. I'm using a straight table with 23 columns. I want to suppress / hide rows where estimate_is_active is blank or otherwise not equal to True and where project_is_active is blank or otherwise not equal to True. So, two conditions and it might be easier to understand my ask this way:
if estimate_is_active = 'True' AND project_is_active = 'True' Then Display the Row, Else Do NOT display the Row
I do have several thousand rows with True for both estimate_is_active and project_is_active as well as rows where both are blank.
As always, thanks in advance for any and all help.
Thank you for the response. I tried your suggestion as an Expression and as a Calculated Dimension. No luck. I still get rows where estimate_is_active and project_is_active are both blank. Should the "and project..." part also have a Len check?
Thanks for the response. I tried your suggestion, but my script fails to load. Please note and I believe this makes a difference, I'm actually loading the data from a SQL Server database using SQL Select and not an Excel file. I provided the Excel file so people could have some sample data.
Thanks for your response. Just to make sure I understand, are you saying that all of the dimensions used should be calculated dimensions using Aggr? I appreciate your patience as I'm still learning. Thanks.