Conditional Show of expression value

[LoKi_asterix]

Hi Guys,

Is it possible to conditionally display the sum of sales only for active customers, where the ‘Status’ (e.g., Active/Inactive) is a dimension that’s transposed over the expression? I want the expression always to reflect only the ‘Active’ status.

[Or]

Perhaps:

Sum({< Status = {'Active'} >} Sales)

[LoKi_asterix]

@Or Just to clarify my requirement, I’d like to display the green square since it represents active sales, and hide the red one (Growth Column) because it’s inactive. Everything else should remain unchanged.

Is that possible?

[Or · Accepted solution]

Unfortunately, you can't do that. You could null the expression but you can't hide the column.