Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator

Accumulated YTD Growth calculation Month wise

I have two years of sales data. Now I have to calculated the month wise  YTD accumulated growth total and I have to view these in line chart or showing the growth trend. The growth formula is , Growth= (TY/LY)*100.

YTD Accumulted total means for month apr it will be , (TY Apr/ LY Apr)*100 

but for month of May it will be, (TY Apr+May)/(LY Apr+May)*100  in trend chart.

Please find the attached data. If anyone have any solution share here.

2 Replies
Not applicable

Hi Koushik,

Can you elaborate more..what is LY,TY, YTD accumulated growth total ???

koushik_btech20
Creator
Creator
Author

CY --> Current Year

LY---> Last Year

YTD accumulated growth total means in data see in apr 2014 the value product A is 200 and in last year means in Apr 2013 the value is 3455 so the value of growth will be 200/3455 i.e. 8.68 but we are calculating YTD accumulated growth total so we we want to calculate apr to may ytd growth total then for apr it will show 8.68 in trend but for may

the calculation will be , Apr 14 + May 14 sale i.e 650 and Apr 13+ May 13 sale i.e 3689, so the value of accumulated growth will be 650/3689 i.e 17.61.