seelction max

[soniasweety]

Hi all, Vegar

i have a region filed     AMS,APJ,EMEA

and month   201601 201602 ,201603,201604,201605,201606,201607....201707   

when i select region   for  AMS  max  month is  201707 to be selected  (as data present for AMS 201707 is max data month)

when i select  for EMEA  max  month is  201707 to be selected  (as data present for AMS 201707 is max data month)

but when i select  APJ  max month is 201607  as we have data for APJ with max month is 201607  how i can i do this?

[DavidM · Accepted solution]

I think you need to specify max month for each region by creating Max field in load script and use that for filter (or in set analysis). Something like this:

Load

Max(Month) as MaxMonth,

Region

Resident Data

Group by Region;

[soniasweety]

i have only one moth field we need to use in front end.

it should be selected default when user selected on perticular region