Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to build a pivot table like the following one. I tried with RangeSum(Above...)) but it doesn't work.
Can somebody help me? Thanks
FiscalYear | Month | Week | Date | Revenues | Year Accumulated Revenues | Month Accumulated Revenues |
2012 | Jun | 1 | 01/06/2012 | 10 | 10 | 10 |
02/06/2012 | 11 | 21 | 21 | |||
03/06/2012 | 12 | 33 | 33 | |||
2 | 04/06/2012 | 13 | 46 | 46 | ||
05/06/2012 | 14 | 60 | 60 | |||
06/06/2012 | 15 | 75 | 75 | |||
07/06/2012 | 16 | 91 | 91 | |||
08/06/2012 | 17 | 108 | 108 | |||
09/06/2012 | 18 | 126 | 126 | |||
10/06/2012 | 19 | 145 | 145 | |||
3 | 11/06/2012 | 20 | 165 | 165 | ||
12/06/2012 | 21 | 186 | 186 | |||
13/06/2012 | 22 | 208 | 208 | |||
14/06/2012 | 23 | 231 | 231 | |||
15/06/2012 | 24 | 255 | 255 | |||
16/06/2012 | 25 | 280 | 280 | |||
17/06/2012 | 26 | 306 | 306 | |||
4 | 18/06/2012 | 27 | 333 | 333 | ||
19/06/2012 | 28 | 361 | 361 | |||
20/06/2012 | 29 | 390 | 390 | |||
21/06/2012 | 30 | 420 | 420 | |||
22/06/2012 | 31 | 451 | 451 | |||
23/06/2012 | 32 | 483 | 483 | |||
24/06/2012 | 33 | 516 | 516 | |||
5 | 25/06/2012 | 34 | 550 | 550 | ||
26/06/2012 | 35 | 585 | 585 | |||
27/06/2012 | 36 | 621 | 621 | |||
28/06/2012 | 37 | 658 | 658 | |||
29/06/2012 | 38 | 696 | 696 | |||
30/06/2012 | 39 | 735 | 735 | |||
Jul | 5 | 01/07/2012 | 40 | 775 | 40 | |
6 | 02/07/2012 | 41 | 816 | 81 | ||
03/07/2012 | 42 | 858 | 123 | |||
04/07/2012 | 43 | 901 | 166 | |||
05/07/2012 | 44 | 945 | 210 | |||
06/07/2012 | 45 | 990 | 255 | |||
07/07/2012 | 46 | 1036 | 301 | |||
08/07/2012 | 47 | 1083 | 348 | |||
7 | 09/07/2012 | 48 | 1131 | 396 | ||
10/07/2012 | 49 | 1180 | 445 | |||
11/07/2012 | 50 | 1230 | 495 | |||
12/07/2012 | 51 | 1281 | 546 | |||
13/07/2012 | 52 | 1333 | 598 | |||
14/07/2012 | 53 | 1386 | 651 | |||
15/07/2012 | 54 | 1440 | 705 | |||
8 | 16/07/2012 | 55 | 1495 | 760 | ||
17/07/2012 | 56 | 1551 | 816 | |||
18/07/2012 | 57 | 1608 | 873 | |||
19/07/2012 | 58 | 1666 | 931 | |||
20/07/2012 | 59 | 1725 | 990 | |||
21/07/2012 | 60 | 1785 | 1050 | |||
22/07/2012 | 61 | 1846 | 1111 | |||
9 | 23/07/2012 | 62 | 1908 | 1173 | ||
24/07/2012 | 63 | 1971 | 1236 | |||
25/07/2012 | 64 | 2035 | 1300 | |||
26/07/2012 | 65 | 2100 | 1365 | |||
27/07/2012 | 66 | 2166 | 1431 | |||
28/07/2012 | 67 | 2233 | 1498 | |||
29/07/2012 | 68 | 2301 | 1566 | |||
10 | 30/07/2012 | 69 | 2370 | 1635 | ||
31/07/2012 | 70 | 2440 | 1705 |
use this expression for accumulation:
=aggr(rangesum(above(sum(Revenue), 0, rowno())), _Date)
use this expression for accumulation:
=aggr(rangesum(above(sum(Revenue), 0, rowno())), _Date)
It works!!!!
I need to study deeply how "aggr" function works.
Thanks a lot!
Corrado