Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Gautham Prasad
Is this what you were expecting ?
-Boo
Please mark correct answer if you find them.
Are you looking for this output?
Changed the start date expression to this:
=If(Sum(sales) > 0, FirstSortedValue({<Period=>}Period, PeriodActual))