Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have 4 Sums in a chart for Jan, Feb, Mar that simply sum up Sale by region. Example:
Jan Feb Mar
NE 1 2 0
SE 2 3 0
SW 1 4 0
Total 4 9 0
And I want to completely hide Mar because it is all 0's. Is this possible?
Put another way, can I hide columns that are all zero?
Thanks much.
Richard,
Try this expression as a conditional show for your expression. You may need to change the dimension name, and the sum statement to the value that's actually in your expression.
if(Max(Aggr(Sum(Sales), Region)) = 0, 0, 1)
Richard,
Try this expression as a conditional show for your expression. You may need to change the dimension name, and the sum statement to the value that's actually in your expression.
if(Max(Aggr(Sum(Sales), Region)) = 0, 0, 1)
Uncheck de option
supress zero value in presentation sheet
Perfect, thanks. Simple!