CAGR issue

[gauthamchilled]

I would like to show the sales for each country of their least year date. each country sales started in different different years. if i select 2015, i dont want to show zero but the sales available for least date or start date.

expected output

Australia  2013 32010

China       2014 70000

Newzealand 2012 2300

Taiwan 2012 310000

attached the file. can any one help?

Thanks

Gautham

[susovan]

Hi Gautham,

Try this attachment,