Create field to filter Option Field

damkjer

I'm creating a special matrix style page (build with PAG99000919 as template in NAV2015). On this i need to have a filter on an option field where I can choose one or more of the option entries.

I don't seem to be able to do that - I only get the possibility to choose one of the values - not as using a filter in Advanced Filter on an option field where I can "tick the boxes" for the relevant options.

Is there a way to achieve this? Hope it makes sense

Rainer

Should it maybe be possible to do this by some code? If yes maybe use..

SETFILTER("Field One",'%1|%2|%3',Option_1,Option_2,Option3)

or

SETFILTER("Field One",'%1..%2|%7',Option_1,Option_4,Option7)

I dont know if this can help you.

Cheers

damkjer

Thanks Rainer, but doesn't make the trick.