Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I go about doing this...
1. I have a Dollar amount as a measure
2. I have A certification as a dimension.
I want to compare the Dollars for having the certification vs not having the certification.
The easy part is Has the Certification...
<$<Certification={'Cert A'}>} DollarAmount
The question is how to do this to get the opposite? Note the below does not work
<$<Certification={'<>Cert A'}>} DollarAmount
As below
=sum({$-<Certification={'Cert A'}>} DollarAmount)
or
=sum({<Certification-={'Cert A'}>} DollarAmount)