Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
which is the easiest way to get max value of running sum by year, quarter, month and day?
Thanks 🙂
I'm not sure exactly what you are trying to do, but it looks like you need Advanced Aggregation:
max( aggr( sum(Sales), Year, Quarter,...))
cheers,
Hi Oleg,
I need max but looking at cumulative sum on yearly, quarterly, monthly and daily levels.
For ex.
Posting date Quantity
1.1.2010. 5
2.1.2010. -4
1.2.2010 1
1.4.2010. 9
1.6.2010. -3
When looking at the year, max cumulative value is 11 (5-4+1+9).
When looking at monthly granualtion, max values are jan:5, feb: 5-4+1 = 2, march: 3, apr: 9+3=12
I know I can't have march unless I create a calendar, but how would i get max cumulative values for the periods in which I do have something posted?
Thnx.