Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=FirstSortedValue(Distinct Aggr(SUM(Data),Date),-Date)
=FirstSortedValue(Distinct Aggr(SUM(Data),Date),-Date)
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