My actual straight table has additional dimensions and expressions, but for simplicity's sake, assume the above. I want my table to always exclude rows for certain customer names irregardless of other selections made, let's say Customer B and Customer C. So what I want to see (at least before other selections are made) is:
Should I be trying to use a calculated dimension here? Something like:
=if([Customer Name]='Customer B' or 'Customer C',' ',[Customer Name])
And then use some kind of 'Suppress When Value is Null'?
Or should I rather be trying to use 'Enable Conditional' on every single Dimension and 'Conditional' on every expression Expression? Something like:
[Customer Name]<>'Customer B' and[Customer Name]<>'Customer C'
I tried the latter approach and Customer B and C still show up in the table when no selections are made; when I actually pick one of them, the table disappears, but they are still in the table to start with.