Forum Discussion
Solved
Cumulative values
Hello everybody, I need your help for a problem. I would like a CUMULATIVE_VALUE in my table. This value is cumulate in fonction of the WEEK and the MONTH. It's easier to understand with tables ...
Hi joc,
You can use year and month column to create a date column ,then use it as the index to calculate the rolling total.
Sample:
Date = DATEVALUE([Month]&" "&[Year])
Cumulative values:
Rolling Total = CALCULATE(SUM(Sheet4[Value]),FILTER(ALL(Sheet4),[Year]=EARLIER(Sheet4[Year])&&[Week]=EARLIER(Sheet4[Week])&&[Date]<=EARLIER(Sheet4[Date])))
Regards,
XIaoxin Sheng
Anonymous Perfect ! Thanks !
Hi joc,
You can use year and month column to create a date column ,then use it as the index to calculate the rolling total.
Sample:
Date = DATEVALUE([Month]&" "&[Year])
Cumulative values:
Rolling Total = CALCULATE(SUM(Sheet4[Value]),FILTER(ALL(Sheet4),[Year]=EARLIER(Sheet4[Year])&&[Week]=EARLIER(Sheet4[Week])&&[Date]<=EARLIER(Sheet4[Date])))
Regards,
XIaoxin Sheng
Anonymous Perfect ! Thanks !