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/2012 | 40 |
| 11/06/2012 | 1200 |
| 11/06/2012 | 200 |
| 11/06/2012 | 500 |
| 11/06/2012 | 500 |
| 11/06/2012 | 19500 |
| 13/06/2012 | 2000 |
| 13/06/2012 | 1000 |
| 29/06/2012 | 10 |
| 28/05/2012 | 100 |
| 28/05/2012 | 120 |
| 28/05/2012 | 200 |
Thanks.
