Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table created as follows:
Customer Name | Invoice | Discount | Discount % |
---|---|---|---|
Customer A | 100 | 5 | 5 |
Customer B | 200 | 6 | 3 |
Customer C | 100 | 7 | 7 |
Customer D | 100 | 7 | 7 |
Customer D | 200 | 10 | 5 |
Customer B | 100 | 3 | 3 |
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:
Customer Name | Invoice | Discount | Discount % |
---|---|---|---|
Customer A | 100 | 5 | 5 |
Customer D | 100 | 7 | 7 |
Customer D | 200 | 10 | 5 |
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.
Thanks all-
I ended up figuring this out myself late last night Here's what worked:
=if([Customer Name]='Customer B', Null(),
if([Customer Name]='Customer C, Null(),
[Customer Name]))
And the suppressing null values. Perhaps not the most elegant solution but it works!
Hi,
There are two methods.
1. You can hide the specific customer names by adding calculated dimension expression as
=If(Not Match([Customer Name],'Customer B','Customer C'),[Customer Name])
and by enabling the Suppress when Value Is Null option.
2. You can use expression as
=If(Not Match([Customer Name],'Customer B','Customer C'), Your Expression) //Expression can be Sum(Sales) or something
You have to write the same for all your expressions.
I have attached sample for your reference.
Use add calculated dimension and write :
=if([Customer Name]<>'Customer B' and [Customer Name]<>'Customer C',[Customer Name])
Thanks all-
I ended up figuring this out myself late last night Here's what worked:
=if([Customer Name]='Customer B', Null(),
if([Customer Name]='Customer C, Null(),
[Customer Name]))
And the suppressing null values. Perhaps not the most elegant solution but it works!