Calculation inside Set analysis

[#1]

Hello,

is it possible to calculate inside set alaysis?

For example:

Column1 -->  count (Distinct {<Stat = {ER}, Filter_DatYYYY = {2014} >} [No_])

Column 2 should be  --> count (Distinct {<Stat = {ER}, Filter_DatYYYY = {2013} >} [No_])

so it should be Filter_DatYYYY = {2014} minus 1

Beste Regards

Georg

[Anonymous · Accepted solution]

you can calculate within set analysis

e.g. with today

Filer_datYYYY={$(=year(today)-1)}

[MK_QSL]

count (Distinct {<Stat = {ER}, Filter_DatYYYY = {'$(=Max(Filter_DatYYYY )-1)'} >} [No_])

[#4]

thx a lot!

[#5]

thx a lot!