Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of month and previous month

Hi,

I want to create a chart in which I should have the sales per month. But for example if in January I have $200 sales and in February I have $50 sales. The chart should look like January = $200 and February = $250.

In other words I want to calculate the sum of sales per month with the previous month. Finally on the last month to have the total sales amount.

Jan = $200

Feb = $50

Mar = $100

April = $70

I should have

Jan - 200

Feb - 250

Mar - 350

April - 420

Can anyone give me an idea how to do this ?

Thanks!

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

You can try the Full Accumulation option also in Expression Tab

or Rangesum(Value,Above(Value))

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

There are useful instruction like

Previous

Above

that you can use

settu_periasamy
Master III
Master III

You can try the Full Accumulation option also in Expression Tab

or Rangesum(Value,Above(Value))

Not applicable
Author

Very helpful. Thanks a lot!