Expression

[narender123]

Hi Team,

I want a expression monthly basis like:

=count({<Charge={2}>}distinct Employee)   "this will show result in against of  month dimention suppose feb"

-

count({<Charge={2},Month={Num(TPMonth) -1}>}distinct Employee)   "then this will show result in against of (month-1) jan"

How i can achieve this??

Thanks,

Narender

[rubenmarin]

Hi Narender, the calculted set analysis for month should be:

count({<Charge={2},Month={'$(=Num(TPMonth) -1)'}>}distinct Employee)   "then this will show result in against of (month-1) jan"

Also notice that set analysis is calculated for the whole table, not row by row, so "$(=Num(TPMonth) -1)" will return only one value based on selections, not dimensions and it won't work when there are more than one possible TPMonth

[#3]

Hi,

I can't understand your question Can you explain it again about input and output