Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I make my group (dVPSUPROGAU) work with this as a dimension?
=if(AU_NUM='848020',null(), dVPSUPROGAU)
Is AU_num one of the fields in the drill down group?
Then add this as a calculated dimension when creating the group
If ( au_num = your number, null (), au_num ())
If this is not a part of the drill down group then add the conditional in the enable condition of the dimension
Is AU_num one of the fields in the drill down group?
Then add this as a calculated dimension when creating the group
If ( au_num = your number, null (), au_num ())
If this is not a part of the drill down group then add the conditional in the enable condition of the dimension
I have a similar situation that I'm hoping you can advise on.
I have a drill down group with CTGY_CODE and ACCT. I need to NULL data for 848020 but I still want the drill down to work. Per your instructions, I am using =if(AU_NUM='848020',null(),CTGY_CODE) for CTGY_CODE and =if(AU_NUM='848020',null(),ACCT) for ACCT. and this hides the data when 848020 is selected but it no longer drills down to the ACCT level.
If I change the expression from =if(AU_NUM='848020',null(),CTGY_CODE) to CTGY_CODE, the drill down to ACCT works but it doesn't obscure 848020 data.