Set analysis. Max date

[MindaugasBacius]

Hello,

I am stuck here with a quite simple task.

I have data like:

Expected output:

2015-01     2

2015-02     4

2015-03     11

Sum of Data in the max date per Year month. This have to be dynamic as here will appear other Calendar fields like [Year week], [Year quarter].

See the attachment.

Thank you for helping me out.

[MK_QSL · Accepted solution]

=FirstSortedValue(Distinct Aggr(SUM(Data),Date),-Date)

[rahulpawarb]

Hello Mindaugas,

You can make use of Resident Load as below:

LOAD [Year month],

MAX(Data) AS Data

Resident BaseTable

Group By  [Year month];

Regards!

Rahul