accmulation in multidimensional pivot table

[cmatcovich]

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

[whiteline · Accepted solution]

use this expression for accumulation:

=aggr(rangesum(above(sum(Revenue), 0, rowno())), _Date)

[cmatcovich]

It works!!!!

I need to study deeply how "aggr" function works.

Thanks a lot!

Corrado