If Statement with Drill Down Group

[cbaqir]

How do I make my group (dVPSUPROGAU) work with this as a dimension?

=if(AU_NUM='848020',null(), dVPSUPROGAU)

[vinieme12 · Accepted solution]

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

[cbaqir]

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.