MTD result accumulated each day

Hello!
I have already build a MTD for sales for the days in the current month. And i have some results. But i have a problem. Im trying to get the sum of sales accumulated per day and rising for each day.

my result today:
date sales
2019-07-01 100
2019-07-02 50
2019-07-03 20

Im trying to get this:
date sales
2019-07-01 100
2019-07-02 150
2019-07-03 170

Now Im only showing the result for the day. Do i have to do something in my mesure?

Thank You!
Steven

Hey Steven - I think a running_total is your best bet - check it out here at https://docs.looker.com/reference/field-reference/measure-type-reference#running_total

Thank you!

I tried but got an error message : filters:’ is not supported for measures of non-aggregate type ‘running_total’

I have a filter in my measure.

@Steven_Ivanoff You can achieve the same thing with a table calculation e.g.

running_total(${transactions.transaction_count})
1 Like

Thank you! It works!