Filter data within a table without adjusting main filter

[#1]

I am sure there is a simple answer to this, but I can't work it out!

I have a table with 3 columns CUSTOMER, CONTRACTVALUE & Flag.

Flag is a 1 or a 0, where 1 means the contract has not yet started delivering revenue.

I want to display a straight table showing all "unstarted" contracts, i.e. where Flag = 1, but I do not want this to affect the overall sheet current selections.

I have tried "Suppress when value is null" in the Flag dimension but it does not work, I assume because the value is 0 and not Null.

I am sure this can be fixed by set analysis {<Flag={1}>} , but everything I try shows both 0 and 1 values.

Can anyone help me?

[blaise · Accepted solution]

make a straight table with an calculated dimension for Flag.

if(Flag=1,1,null())

And supress values when null for that dimension.

If you have an expression in your straight table you should use sum(if(Flag=1,someFieldtoSum,null()) instead.

[#3]

Great. Thanks for your help with this. It works perfectly