Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have attached sample excel sheet I wanted to create a line chart with Yoy Growth Analysis for 3 Years
Year Growth
2011 40 %
2012 25.1 %
2013 35.12 %
How to calculate and show in chart ?
Regards
Vikas
(sum(Growth)/Above(sum(Growth))-1)
=If(GetSelectedCount(Year)=1,Sum(Growth)-Above(Sum(Growth))/Above(Sum(Growth))*100,Sum(Growth))
You can use the Above function or use an AsOf table. See attached app.
Thanks Gysbert Wassenaar
I will check and come back you.
Vikas