RangeSum above can do that ?

[Chuayuko]

Hi all,

I have a pivot table.

Current result:

Period		202003	202004	202005	202006	202007
Expired membership - Main		86	52	47	57	57
Expired membership - Sub		2	55	48	59	57

Expect Result:

Period		202003	202004	202005
Expired membership - Main		299	213	161
Expired membership - Sub		221	219	164

Example

column 202003, = 86+52+47+57+57

column 202004, = 52+47+57+57

I am no idea how to do that

2 Dimensions:

=if(ITEM='MainExp','Expired membership - Main',if(ITEM='SubExp','Expired membership - Sub')) (Label: Period)

MthYear

Expressions:

RangeSum(Above(count(ITEM), 0, columnno(TOTAL)))

Thanks