Joiners and Leavers in Sense

[cleblois]

Hi,

We want to analyse our products with a focus on joiners and leavers.

I found the beginning of it on the forum but now I'm stuck.

In below example, leavers for 2012 and joiners for 2013 are correct because I fixed the values in the formula.

My issue is to make it generic for this table in Sense.

current formulas:

* joiners: Count( DISTINCT {$ < DPN= P({<Year_QVW={'2013'}>} DPN)- P({<Year_QVW={'2012'} >} DPN)>} DPN)

* Leavers: Count( DISTINCT {$ < DPN= P({<Year_QVW={'2012'}>} DPN)- P({<Year_QVW={'2013'}>} DPN)>} DPN)

When I use max in the P(), it considers 2015, the max year of my selection, not the year of my column.

any idea to repalce my fixed years by years relative to my columns?

Thanks in advance,

Christophe