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: 
khan_imran
Creator II
Creator II

Finding average based on cumulative value

Hello All,

I am trying to find out the average based on Cumulative value. I am having month-on-month Sales against the target and I am accumulating Sales & Target to find out the average at of all cumulative achievement.

Achievement column is arrived by dividing Sales Cumulative with Target Cumulative for each month and at the end I am taking an average of Achievement(available in the bottom of the table.

Attached is the excel data and same table in the body of a post. Kindly help me to achieve this.

   

PeriodSalesTargetSales CumulativeTarget CumulativeAchievement
Apr-172333732851452333732851450.8184
May-172588332856254922065707700.8624
Jun-172637392892277559458599970.8790
Jul-17267500288485102344511484820.8911
Aug-17262353293371128579814418530.8918
Sep-17263681313837154947917556900.8825
Oct-17289252349769183873121054590.8733
Nov-17265604292821210433523982800.8774
Dec-17271100337227237543527355070.8684
Jan-18290964365542266639931010490.8598
Feb-18282962331017294936134320660.8594
Mar-183788240286298724334723520.8603
Average0.8687

Regards,

Imran K

1 Solution

Accepted Solutions
3 Replies
qv_testing
Specialist II
Specialist II

Like,  Avg(Achivement)

khan_imran
Creator II
Creator II
Author

I want to achieve average. however to achieve average rest 2 column also need to be achieved. I am just having first 2 column and rest 3 needs to be calculated to achieve my final output,

qv_testing
Specialist II
Specialist II

PFA,