Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a dimension that shows up as null but has quota information on it that I need. I want to hide the "-" but keep the 544,023 that shows up at the bottom. The problem I have is that if I click "suppress null values" under Model then the 544,023 is not calculated. How can I keep the amount in the null value but hide the null dimension itself?
Model | Brand | Quota |
CAPITAL | PLYO | $0 |
DEVICE | PLYO | $0 |
DEVICE | CYNO | 0 |
OPTIONS | PLYO | $0 |
- | CYNO | $544,023 |
$544,023 |
So I want it to look like this:
Model | ]Brand | Total Quota |
CAPITAL | PLYO | $0 |
DEVICE | PLYO | $0 |
DEVICE | CYNO | $0 |
OPTIONS | PLYO | $0 |
$544,023 |
Please try using calculated dimensions
May be dimensionality() function can help you do that
I actually am using dimensionality but it does not help with hiding the null value.
Would you be able to share a sample where you are doing this?
Please try using calculated dimensions
Try as dimension:
=if(len(trim(Brand))=0,'',Brand)
result:
Thank you! a variation of this worked for me.
Thank you, Omar. The isnull expression above worked for me so I did not test this solution but I greatly appreciate the response!
Cleaner with the new coalesce function
Aggr(Coalesce(Model,''))