Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like, Avg(Achivement)
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,
PFA,