Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I’m having some problem with accumulated calculations
In the table below you can see the outcome of the accumulated calculation by checking the “full accumulation” check box in the expression.
I need the accumulation calculation to be in the other way,
From the bottom to the top.
When I change the sorting, the accumulation calculation is changed, but then I have the latest date at the bottom and I like to have3it on the top.
C_Date | A_Accumulated | A |
7/23/2013 | 3,796 | 3,796 |
7/22/2013 | 7,381 | 3,585 |
7/21/2013 | 11,278 | 3,897 |
7/20/2013 | 16,582 | 5,304 |
7/19/2013 | 33,371 | 16,789 |
7/18/2013 | 36,443 | 3,072 |
7/17/2013 | 39,595 | 3,152 |
7/16/2013 | 42,783 | 3,188 |
7/15/2013 | 46,015 | 3,232 |
7/14/2013 | 49,272 | 3,257 |
7/13/2013 | 52,588 | 3,316 |
07/12/2013 | 55,996 | 3,408 |
07/11/2013 | 59,762 | 3,766 |
07/10/2013 | 64,799 | 5,037 |
07/09/2013 | 69,634 | 4,835 |
07/08/2013 | 74,001 | 4,367 |
07/07/2013 | 77,504 | 3,503 |
07/06/2013 | 80,660 | 3,156 |
07/05/2013 | 83,828 | 3,168 |
07/04/2013 | 87,098 | 3,270 |
07/03/2013 | 90,422 | 3,324 |
07/02/2013 | 94,004 | 3,582 |
07/01/2013 | 97,570 | 3,566 |
Thanks in advance.
try this
Updated By me If You have More than one dimension then
aggr(rangesum(above(sum(Fieldname),0,rowno())),C_Date)
nope.
but it helped.
Sum (total A) - rangesum(above(sum(A),0,rowno())))
Somthing like that.
Thanks.