How to ignore sub-category values when applying drill down in matrix?

[Anonymous]

Hi Community,

I am wondering if there is any way to not show the sub-category values while keeping the row total in the matrix. For example in the below matrix, is there any way to only show the subcategories (a1, a2, a3, a4), but not showing their values (1, 5, 4, 2)? The desirable format would be like the second picture.

 

 Any help would be greatly appreciated. Thanks in advance!

[littlemojopuppy · Accepted solution]

Hi @Anonymous .  You should be able to accomplish that with the ISINSCOPE() function.  There's a pretty good code example on the page as well...

[Anonymous]

This works! Thank you for the help!

[littlemojopuppy]

@Anonymous de nada!  Glad I could help!