How do you make values from an expression appear only in subtotal rows?

[#1]

I have two expression columns that are only useful for my subtotal and grand total rows. I need a way to suppress all the other values in these two columns.

Thank you for any suggestions!

[stabben23 · Accepted solution]

Hi,

use something like that in textcoulor in your expression:

if(Dimensionality()=2, white())

//Stabben

[Gysbert_Wassenaar]

By using the dimensionality() function. See attached example. Note, if don't have any expressions that should show values at the detail level then you need to disable Suppress Zero-values or you will see no detail rows.

[#4]

Thank you, that was exactly what I needed!