Firstsortedvalue not working

[gauthamchilled]

i would like to show startdate of sales for each country ..my date format is like below

fy2015,20152

my2015,20151

fy2014,20142

my2014,20141

just want to show start date as first sales date or first business started year.

can you help please?

[boopeshj]

Hi Gautham Prasad

Is this what you were expecting ?

-Boo

Please mark correct answer if you find them.

[sunny_talwar]

Are you looking for this output?

Changed the start date expression to this:

=If(Sum(sales) > 0, FirstSortedValue({<Period=>}Period, PeriodActual))