Hide rows in a chart table using conditionals

[#1]

Hi,

I hope someone can help me. I'm trying to hide rows within a chart table when a condition is true.

I have one dimension called Employee and one of my expresions is LeaveDate.

Basically I need to hide all those rows where LeaveDate < Today()

How can I do that?

I have tried using the conditional field in the Dimensions tab but it didn't make any difference.

Any ideas would be appreciated.

Thanks a lot.

[giakoum]

sum({$<[LeaveDate]={"<$(=Today())"}>} [Some Field])

Maybe Suppress When Value Is Null check is also needed (Dimensions tab of chart)

[MayilVahanan · Accepted solution]

HI

     Use if(LeaveDate < Today(),express) in all expression, it will hide the values..

     or use set analysis in expressions..

     Make sure, both leavedate and today() are in same format.

     Hope it helps