Get New Customer and uneventful customers

Hi.

There will be a way of doing it, Might need to know a little more about the data to give an exact answer, but i would look to create a new table in the data.

This will have to link to back on Customer, season and you need to create a flag, to see if they ordered in this season.

Then you could use the Previous or Peek function to check if they order last season. Making sure it is ordered by customer and season, somthing like

IF(CodeCustomer=Peek('Codecustomer',-1),

     PEEK('OrderedFlag',-1)

   )          AS OrderLastSeason.

Then each line of data will have a flag for order this season and last season, so will be dynamic to your season selections.

Mark

let's try using the below expressions:

//for new customers:

=count( {< CodeCustomer = P( {< IndexSeason = {"$(=Concat( distinct IndexSeason,','))"} >} ) * E( {< IndexSeason = {">=$(=Concat( distinct IndexSeason,',')-2)<=$(=Concat( distinct IndexSeason,',')-1)"} >} ) >} distinct CodeCustomer )

//for  uneventful customers:

=count( {< CodeCustomer = P( {< IndexSeason = {"$(=Concat( distinct IndexSeason,',')-1)"} >} ) * E( {< IndexSeason = {"$(=Concat( distinct IndexSeason,','))"} >} ) >} distinct CodeCustomer )

in this way the user can select the current season from a listbox.