5 Replies Latest reply: Nov 18, 2012 9:54 AM by Max Pol RSS

    How exclude Rows from table?

    Max Pol

      I have next script:

       

      LOAD * INLINE [

          INV, QTYINV, DATAINV

          N1, 100, 01.01.2012

          N2, 1000, 01.02.2012

          N3, 6000, 01.03.2012

          N4, 1500, 01.04.2012

          N5, 900, 01.05.2012

          N6, 1200, 01.06.2012

      ];

       

      LOAD * INLINE [

          SHI, INV, QTYSHI, DATASHI

          P1, N1, 100, 15.01.2012

          P2, N2, 800, 15.02.2012

          P3, N2, 100, 16.02.2012

          P4, N3, 5000, 15.03.2012

          P5, N3, 1000, 16.03.2012

          P6, N4, 1400, 15.04.2012

          P7, N5, 700, 15.05.2012

          P8, N6, 1200, 15.06.2012

      ];

       

       

      And I have in diagramm Table:

      Colomn1 Dimension:

      INV

      Colomn 2 Expression:

      QTYINV-Sum({1}QTYSHI)

      Colomn 3 Expression:

      DATASHI-DATAINV

       

      I need, that in the table will be the rows, where Colomn 2 <> 0.

       

      Nowday I have this:

      INVCOLOMN 2DATASHI-DATAINV
      --
      N1014
      N2100-
      N410014
      N520014
      N6014

       

      But I need:

       

      INVCOLOMN 2DATASHI-DATAINV

      N2100-
      N410014
      N520014

       

      Please, help me, how I can exclude Rows?