Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to hide certain values depending on the value of the expression that is chose. I want to display the value in the expression so that other dimensions in the chart will be displayed. I just want one dimension for certain values to display as null. I'm not sure where to begin.
post some sample data.
In the Risk Summary Report chart I would like to hide the value in the % Files Reviewed dimension if the value of the Doc Type is "ASN" or "END".
you have two options. See attached.
Option 1:
=if(wildmatch([Doc Type],'ASN','END'),' ',
[Loan Count]/Count({1<[WeekEnding], [Pool] = {'$(vPool)'}>}[Loan ID]))
Option 2:
=[Loan Count]/Count({1<[WeekEnding],[Doc Type]-={'ASN','END'},[Pool] = {'$(vPool)'}>}[Loan ID])
If you want to hide the column '% Files Reviewed' upon selecting 'ASN' or 'END' from 'Doc Type', see attached.