Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
sum({$<[LeaveDate]={"<$(=Today())"}>} [Some Field])
Maybe Suppress When Value Is Null check is also needed (Dimensions tab of chart)
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