0 Replies Latest reply: Jun 28, 2012 5:14 AM by jialiang RSS

    Bar chart automatically display and hide (conditional) expressions upon system date

      Hi,

      I have data as below. I have expressed the arriving shipment quantities by future shipment arriving dates (converted in months), in the waterfall chart. I would like to set conditions for each of the expression, to be displayed the respectively when the corresponding arriving shipment date ([Shipmt ETA]) is > Today() (System Date), and hidden when there is no arriving shipment on that particular month([Shipmt ETA]).

       

      How should I set the conditions to let the expressions to be displayed and hidden automatically, without using any action in button or text object?

       

      Shipmt ETA
      Shipmt Qty
      01/06/201240
      11/06/20121200
      11/06/2012200
      11/06/2012500
      11/06/2012500
      11/06/201219500
      13/06/20122000
      13/06/20121000
      29/06/201210
      28/05/2012100
      28/05/2012120
      28/05/2012200

       

      Thanks.