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