adding multiple filter

[Anonymous]

Hello,

Can you please help me in adding multiple filter in #kpi

At present i have used this formula

Count({$<Position={"changed"}>}distinct [Customer Name])

now i need to add another filter (year = 2016) to this.

Thank you in advance,

Sachin

[luismadriz]

Hi,

please try this if year is numeric:

Count({$<Position={"changed"},year={2016}>}distinct [Customer Name])

I hope this helps,

Cheers,

Luis

[Anonymous]

Hello Luis,

This works, Thanks a lot.

Cheers,

Sachin

[luismadriz]

Good,

When you get a chance please close the thread by marking helpful/correct replies,

Cheers,

Luis