Check box to exclude value

[richard_chilvers]

In my table every record has a value in REC_TYPE of A, B, C, D.

In my dashboard, I want to always show records with values in REC_TYPE of A and B, and also default to include values of C and D.

But I want 2 check boxes:

Click Here to EXCLUDE REC_TYPE of C   [  ]

Click Here to EXCLUDE REC_TYPE of D   [  ]

Please advise a neat way to do this, or point me to the correct place on this forum.

Thanks

[richard_chilvers]

I'm always conscious of supporting apps and deciding whether a development investment is worth the value it gives the end user. For my organisation it would be difficult for us to support/justify a complex formula such as this:

='=Sum({1<Type -= {$(=GetFieldSelections(RecType, chr(44)))} >} 1)'

I'm sure many developers for other organisations do this and more complicated apps.

But thanks for your help.

[vikasmahajan]

cool

Vikas