Forum Discussion
jlamprecht
7 years agoRegular Visitor
Cumulative total by group
I know how to create a running total column with
calculate( sum ( table[Values]), all(table), table[date] <= earlier (table[date]) )
however, I have several jobs on one table that need their own running totals. Sample data would be:
Job Period Amount Running Total
Job1 201901 5000 5000
Job1 201902 10000 15000
Job2 201901 3000 3000
Job2 201902 4000 7000
What is the best way to do this? I think I need to do it as a column since on the report page, there is a date filter and the running total needs to go to the beginning of time regardless of the report filter.
Thank you!
jlamprecht try this
calculate( sum ( table[Values]), allexcept(table, table[job]), table[date] <= earlier (table[date]) )
2 Replies
- parry2k
Super User
jlamprecht try this
calculate( sum ( table[Values]), allexcept(table, table[job]), table[date] <= earlier (table[date]) )
- jlamprechtRegular Visitor
That is working perfectly!