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.
Describe more? How date is Less than The number??
The date is month number. For example, I get 0 in first raw, because I haven't observation with date less 6, I get 30 in second raw, because I have two observations with date less 7.(15+15)
Not sure, Still i followed you. What this returns?
If(Date < volume, Sum(volume))
Oh, no, I need compare dates
Can you explain little in technical.. I believe you may need Above() and Below()
I'm not sure, because I need universal design.I mean, I need compare all dates with date in dimension. And after that I sum volumes, for which dates satisfy the condition.And I need do it for all raws.
NP, Anyway he may offer you vinieme12
Thx
May be this?
Aggr( NODISTINCT RangeSum(Above(TOTAL Sum(volume),1,RowNo(TOTAL))),Date)