Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I want to get last value of accumulated
Like that
Account | Date | Value | Accumulate |
---|---|---|---|
A | 1/1/2018 | 10 | 10 |
A | 2/1/2018 | 9 | 19 |
A | 3/1/2018 | 4 | 23 |
B | 1/1/2018 | 5 | 5 |
B | 2/1/2018 | 2 | 7 |
B | 3/1/2018 | 7 | 14 |
I just want to last value in this example are A = 23 and B = 14
Thanks for your help
Hi Phong,
You could have an expression like sum(Value) as your Accumulate and another one as max(Date) instead of Date being a dimension.
So your dimension would be Account, the first expression Date(max(Date)) and the second expression sum(Value).
Regards,
Sorin.
Hi Phong,
You could have an expression like sum(Value) as your Accumulate and another one as max(Date) instead of Date being a dimension.
So your dimension would be Account, the first expression Date(max(Date)) and the second expression sum(Value).
Regards,
Sorin.