Sum values from different Max(dates) depending on Country.

[Bobi]

Hi. I have accumulated data from a table and need to display the sum of the latest captured date.

Formula is like below:

sum({<Date={"$(=Max({<Transactions={'Orders}>}Date))"}>} Counter)

This works fine beside the fact that I have Countries with different Max-Date. Meaning if latest Data for Germany is 24 of march and French is 25 of March I will only capture French. I need to capture max(date) since it is accumulated data.

Is there any way I can solve this (get the maxdate depending on which country it is and then sum it up), tried some variants with aggr and so on but without solving it..

[MadiF · Accepted solution]

@Bobi  Try adding this general logic to your load script, after the initial load of your table (which I here call 'Table1'):

Left join (Table 1) Load

     CountryField,

     max(DateField) as MaxDateByCountry

Resident Table1 Group by CountryField;