Finding average based on cumulative value

[khan_imran]

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.

Period	Sales	Target	Sales Cumulative	Target Cumulative	Achievement
Apr-17	233373	285145	233373	285145	0.8184
May-17	258833	285625	492206	570770	0.8624
Jun-17	263739	289227	755945	859997	0.8790
Jul-17	267500	288485	1023445	1148482	0.8911
Aug-17	262353	293371	1285798	1441853	0.8918
Sep-17	263681	313837	1549479	1755690	0.8825
Oct-17	289252	349769	1838731	2105459	0.8733
Nov-17	265604	292821	2104335	2398280	0.8774
Dec-17	271100	337227	2375435	2735507	0.8684
Jan-18	290964	365542	2666399	3101049	0.8598
Feb-18	282962	331017	2949361	3432066	0.8594
Mar-18	37882	40286	2987243	3472352	0.8603
				Average	0.8687

Regards,

Imran K

[qv_testing]

Like,  Avg(Achivement)

[khan_imran]

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 · Accepted solution]

PFA,