Pick max value (with respect to date) for each month and account and accumulate it for every month

[muhammadraza]

Hello Guyz,

I have the following data-set

From this data-set I have to pick the maximum value (with respect to date)  for each month and for each account accumulate it and display in a table as shown

Please guide how can I achieve this.

The qvw and excel sheet file are attached.

Regards,

Muhammad Raza

[maxgro]

try with

dimension       month

expression      sum(aggr(FirstSortedValue(Balance, -AsOfDate), Account, month))

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.