2 Replies Latest reply: Sep 12, 2012 9:45 AM by mayilvahanan ramasamy RSS

    Hide rows in a chart table using conditionals

      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.