Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have straight table with dimension as Date and expression1 as sum(sales) and expression2 as sum(sales). but the second expression I need running totals. so, I used full accumulation for second expression. but it is not working. it is showing same data as first expression. can anyone suggest me how to do this
Date | ID | expression1 | expression2 |
23/04/2013 | 1 | 3.41 | 3.41 |
23/04/2013 | 23 | 79.15 | 79.15 |
25/04/2013 | 34 | 79.15 | 158.3 |
26/05/2015 | 1 | 2.34 | 160.64 |
31/07/2015 | 23 | 512.65 | 673.29 |
23/04/2013 | 1 | 15423.62 | 15423.62 |
25/04/2013 | 213 | 15423.62 | 30847.24 |
11/02/2015 | 345 | 6009.73 | 36856.97 |
23/04/2013 | 456 | 706.57 | 706.57 |
08/05/2013 | 321 | 2378.27 | 3084.84 |
31/07/2013 | 12 | 390.07 | 3474.91 |
need output as below
Date | ID | expression2 | expression2 |
23/04/2013 | 1 | 3.41 | 3.41 |
23/04/2013 | 23 | 79.15 | 82.56 |
25/04/2013 | 34 | 79.15 | 259549.12 |
26/05/2015 | 1 | 2.34 | 259549.12 |
31/07/2015 | 23 | 512.65 | 259549.12 |
23/04/2013 | 1 | 15423.62 | 245053.69 |
25/04/2013 | 213 | 15423.62 | 991558.54 |
11/02/2015 | 345 | 6009.73 | 991558.54 |
23/04/2013 | 456 | 706.57 | 1240.21 |
08/05/2013 | 321 | 2378.27 | 539775.13 |
31/07/2013 | 12 | 390.07 | 5518098.033 |
Please can anyone suggest how to get this.
Thanks.
Use
RangeSum(Above(YourExpression,0,RowNo()))
or
RangeSum(Above(TOTAL YourExpression,0,RowNo()))
Accumulation only works well when you use only one dimension.
If you use more than one, please use MRKachhiaIMP solution
hi Amelia D
=sum(expression1) or =sum(expression2) give both expressions on stright table give total sum in below
Thanks. I have used this but this is not working. expression2 showing same as expression1
Provide your sample app with dummy data..
hi