Hello, I would need some in calculating a running total.
| Monthname(Date) |
Product |
Start of month Balance |
sum(sales) |
sum(payout) |
End of month Balance |
| Jan-22 |
A |
0 |
100 |
0 |
0 + 100 - 0 = 100 |
| Feb-22 |
A |
100 |
150 |
50 |
100 + 150 - 50 = 200 |
| Mar-22 |
A |
200 |
50 |
200 |
200 + 50 - 200 = 50 |
| |
|
|
|
|
|
| Jan-22 |
B |
0 |
200 |
0 |
200 |
| Feb-22 |
B |
200 |
50 |
100 |
200 + 50 - 100 = 150 |
| Mar-22 |
B |
150 |
100 |
50 |
|
| Apr-22 |
B |
|
80 |
50 |
|
I have a dataset with Date, Sales and Payout. I want to calculate on a product level (with date of course). I will have for each product at the start of the first month has 0 sales at first then we add the sales of that month and then we substract the payout. This new value will be the starting value of the next month and so on. Can you anyone help me? I tried with above/rangesum but I didn't get the expected values
