6 Replies Latest reply: Oct 6, 2012 7:08 AM by Gysbert Wassenaar RSS

    Conditional display of data on a straight table

      Hi guys,

       

      I have quick question. I hope someone has a simple answer.

       

      I have the following data output in a straight table where CLIENT_KEY and DATE are dimension fields and AMOUNT is an expression.

       

       

      CLIENT_KEYDATEAMOUNT
      R101505-Sep-12-18,192
      R101506-Sep-122,889
      R101510-Sep-125,819
      R172018-Sep-126,450
      R172028-Sep-12-70
      R172001-Oct-12-23
      R172004-Oct-121,678

       

       

      I would like to only display the latest positive AMOUNT values for a given CLIENT_KEY. So it would be chronogically all the positive values for AMOUNT till it becomes negative. The data i would like to be removed from the table is can striked through. Does anyone have any ideas as to how it can be done?

       

       

      CLIENT_KEYDATEAMOUNT
      R101505-Sep-12-18,192
      R101506-Sep-122,889
      R101510-Sep-125,819
      R172018-Sep-126,450
      R172028-Sep-12-70
      R172001-Oct-12-23
      R172004-Oct-121,678