2 Replies Latest reply: Sep 12, 2012 9:45 AM by Mayil Vahanan Ramasamy RSS

    Hide rows in a chart table using conditionals



      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.