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

[#2]

choose Country as Dimension

Use expression:

firstsortedvalue({<Year=>}Sales,Year)

[tamilarasu]

Hi Gautham,

Have a look at the attachment.

[gauthamchilled]

Thanks tamil, i want to show max year sales in next column also. similar to min year sales. how can i do that?

[gauthamchilled]

actually i wanted to calculate CAGR..it works in text box on the line chart...but i wanted to show it in straight table with country as dimension it is not working

=pow(sum({$<Year={$(=max(Year))}>} sales)/sum({$<Year={$(=min(Year))}>}

sales),1/(max(Year)-min(Year)))-1

[tamilarasu]

Gautham,

You can add - sign before the sort-weight to get Max Period sales.

FirstSortedValue(Sales, -Period)

[gauthamchilled]

but i couldnt able to achieve using firstsortedvalue while calculating CAGR.

[tamilarasu]

Gautham,

I just want to cross verify the calculated values. Could you provide me your expected result / output for CAGR.

[tamilarasu]

Try this expression,

Pow((FirstSortedValue({1}Sales, -Period)/FirstSortedValue({1}Sales, Period)),1/(FirstSortedValue({1}Period, -Period)-FirstSortedValue({1}Period, Period)))-1

[gauthamchilled]

FirstSortedValue(Country,Period) as expression and country as dimension in straight table returns nothing...what could be the reason? any idea?