Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some dimensions and one of it is date. Also I have a few volumes for each date. I need to get sum of volumes, for which date less then in dimension.
For example
Dim 1, Dim 2, Date, volume, sum of volumes less date
A, AA,. 6,. 15,. 0
A,. AB,. 7,. 5, 30
B,. BA,. 6,. 15,. 0
B,. BB,. 8,. 10,. 35
I can't understand how to compare dates for each row with date in dimension and get sum.
May be something like this
sum(aggr( rangesum(above(sum(volume),0,RowNo(TOTAL) )) - sum(volume) ,Date))

what is the expected output?