Forum Discussion

y3wan's avatar
y3wan
Frequent Visitor
4 years ago
Solved

Cumulative total

Anyone know why the forumula didnt generate a cummulative total instead?

I was expecting 12, 18 & 48.

 

 

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I think it is because SUM('Sheet1'[Cost]) on the first row is already 48. Please try the below calculated column.

     

    ColumnCC =
SUMX (
    FILTER ( Sheet1, Sheet1[Date] <= EARLIER ( Sheet1[Date] ) ),
    Sheet1[Cost]
)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    I think it is because SUM('Sheet1'[Cost]) on the first row is already 48. Please try the below calculated column.

     

    ColumnCC =
SUMX (
    FILTER ( Sheet1, Sheet1[Date] <= EARLIER ( Sheet1[Date] ) ),
    Sheet1[Cost]
)
    • y3wan's avatar
      y3wan
      Frequent Visitor
      4 years ago

      It works beautifully. Thank you