9 Replies Latest reply: Jun 17, 2016 8:28 AM by Manish Kachhia RSS

    number records aggregated on dimension



      I got a table INVOICE and I'm selecting 3 fields from this table: ITM_ID_T (item identifier), INV_ID_T (invoice identifier) and I_VALUE as total value for respective INV_ID_T.
      In the data set it may happen 1 ITM_ID_T has associated more than 1 INV_ID_T.

      My goal is to get them counted, so I can tell which INV_ID_T was added as the first one.


      I will appreciate any help.