7 Replies Latest reply: Sep 26, 2018 10:04 AM by Andrea Gigliotti RSS

    cumulative table with sum cash applied versus total invoiced$ per month

    Ugur Arslan

      Dear all,

       

      I have table with the following dimension and measurement:

       

      Dimension:

      day([Month date])

       

      Measurement:

      (Sum({<[Year Month]={'$(Current_Month_YYYYMM)'}>}[Cash App Amt USD])

      /

      Sum({<[Year Month]={'$(Current_Month_YYYYMM)'},[Trans Type]={'invoice'}>}total <[Year Month]>[Trans Amt USD]))

       

      Table now shows:

       

      Days is created by using dimension Day([month date])

      Measurement by using:

      (Sum({<[Year Month]={'$(Current_Month_YYYYMM)'}>}[Cash App Amt USD])

      /

      Sum({<[Year Month]={'$(Current_Month_YYYYMM)'},[Trans Type]={'invoice'}>}total <[Year Month]>[Trans Amt USD]))

       

       

      DaysMeasurement
      16
      23
      35
      46
      58
      68
      74
      83
      96
      107
      118
      128
      138
      148
      159
      169
      176
      184
      193
      202

       

       

      Now I want to see this result as cumulative.

       

      DayCumulative
      16
      29
      314
      420
      528
      636
      740
      843
      949
      1056
      1164
      1272
      1380
      1488
      1597
      16106
      17112
      18116
      19119
      20121

       

       

      How do I need to do this?

       

      Please help me.

       

      Ugur