sum of last day of month

[amien]

i have a table (see attachment) with this structure:

date, dateYYYYMM, dateYYYYWW, Player, Team, Value1, Value2

Value1 is not cumulative (not added in sample) .. Value2 is cumulative until the end of the month.

what i want is the sum of all values2, but only from the last date of each month.

so i would like a bar chart for each month and the sum of value2 from each user, but only of the lastest day of that month.

(if i would sum each day, i would have way too many).

extra: its possible that we date field is filled, but no data set. If that is the case, it should take the last date that has values (value2).

Thanks in advance

btw .. i'm looking for a expression solution .. not a load solution

[amien]

Sum({$<DatumYYYYMMDD = {$(=DATE(MAX(DatumYYYYMMDD),'YYYYMMDD'))}>} Value)

this gives me the value that i need .. but i only get 1 month (last month data) .. i need this for all months. how can i do this?

[#3]

Hi,

First thing you should load the month value by calculating the month either by using "monthname" or by any other function instead of just representing the date in YYYYMM format.

Once you load it like that then you can use the expression in the attached application for your required result.

Thanks & Best Regards,

Kuldeep Tak