Hiding Rows Based On Blank Fields

[pnn44794]

Hello:

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.

[vishsaggi]

Technically yes, or if you don't have any typical expressions to be used, just add few dimensions with Aggr and add rest of your dimensions in your expression tab as your normal dimensions fields ?

[pnn44794]

Hello Carlos:

Thanks for your reply.  I tried your suggestion above and after I removed the other expression which was just simply [DM #], it appears to have worked!  I did expect more rows than what I'm seeing to be returned, so I may still have something wrong on my side.  I will look at it further tonight and tomorrow if need be.  Thank you.  I appreciate the help.

[Anonymous]

When using a preceding load in combination with sql selects there shouldn't be any difference.

So please post your script...