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?

[MayilVahanan]

Hi

Try like this

country	Start Date
Chile	FY2014
China	MY2014
Switzerland	FY2013
UK	MY2013
US	FY2013

=FirstSortedValue(Period, PeriodActual)

Or

in back end

Test:

Load * inline

[

Period, PeriodActual,country,sales

FY2015,20152,Switzerland,23000

FY2013,20132,Switzerland,13000

MY2015,20151,China,121000

FY2014,20142,Chile,221211

MY2014,20141,China,21300

FY2013,20132,US,321310

FY2015,20152,US,321313

MY2013,20131,UK,311421

];

LOAD country, FirstSortedValue(Period, PeriodActual)  as StartDate Resident Test

Group by country;

country	StartDate
Chile	FY2014
China	MY2014
Switzerland	FY2013
UK	MY2013
US	FY2013

[gauthamchilled]

Thanks mayil, but =FirstSortedValue(Period, PeriodActual) is not working , find the attachment and can you help to look please

[raju_insights]

Hi Gautham Prasad,

Your requirement is not clear. Can you show us required output ?

[gauthamchilled]

output is already available in the thread

[ramasaisaksoft]

Hi Gautham,

1)As per your text object,you mentioned 2012 but there is no 2012 year

2)The data which you provide is not understandable for me

you want to show like

if business starts in  US at  2012 you want 2012 sales only even though you selected any year in Filter am i right?

like that

even though you select 2014 as year for country Switzerland (this country starts the business 2 times in 2013 and 2015 so which one we need to show in data?)

sorry i am unable to understand your question tha's way i am asking these many questions

i hope you will get start year data  for country wise ,you need to write set analysis/If conditions for each and every country.

[gauthamchilled]

Mayils firstsortedvalue function is working but not working if i select any period from the filter..i think i need to show date irrespective of current selected year

[MayilVahanan]

Hi

try like this

=FirstSortedValue({<Period=>}Period, PeriodActual)

Or go for Back end process.

[ramasaisaksoft]

Hi Gautham,,

take a Staraight table objetct,

dim: Country

Expr :FirstSortedValue(Period,PeriodActual)

then you will get your solution

else

in code/script  level you can fallow mayilvahanan solution

[gauthamchilled]

Thanks mayilvahanan‌

I did the same, but it show 0 values for all the countries sales even though they dont have sales. start date is working fine.

Is there any way to get rid of those zeros..attached the file