# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Running Total kind of...

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

Labels (1)