Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What formula should I use to calculate the year on year growth figures for cumulative months?
ie.
Jan13 vs Jan12
Jan13+Feb13 vs Jan12+Feb12 (cumulative)
Jan13+Feb13+Mar13 vs Jan12+Feb12+Mar12 (cumulative)
etc.
Attached sample data.
Thanks!
Hi,
Have a look at the application attached.
Regards,
Kaushik Solanki
Hi Kaushik,
Thanks for yr quick reply! Besides 'Total', how do I also display out the cumulative figure of 'A', 'B' and 'C' values? Previously I had used the range sum function to calculate year to date figures. How do I do a subtraction of Jan-Apr13 figures from Jan-Apr12 figures for a year on year comparison?