Dears,
I need to calculate Month to Date sales - day by day, but i get the same value for sales as:
| Month/Day | 12/1 | 12/2 | 12/3 | 12/4 | 12/5 |
| Sales | -15,608,809.37 | -16,142,777.27 | -16,368,495.52 | -15,187,632.97 | -14,702,194.26 |
| Month to Date Sales | -15,608,809.37 | -16,142,777.27 | -16,368,495.52 | -15,187,632.97 | -14,702,194.26 |
"Sales" is already a measure with sum of total amounts of sales this day.
I need it to be like this:
| Month/Day | 12/1 | 12/2 | 12/3 | 12/4 | 12/5 |
| Sales | -15,608,809.37 | -16,142,777.27 | -16,368,495.52 | -15,187,632.97 | -14,702,194.26 |
| Month to Date Sales | -15,608,809.37 | -31,751,586.64 | -48,120,082.16 | -63,307,715.13 | -78,009,909.39 |
