Conditional display on straight table

[Anonymous]

Hi ,

Below is my sample data.my requirement is if the end user selects a month,I want to display that month data and also data which is not associated to any month.(ex:if end user selects JAN then that should display JOBS 1,5,7).Any help is appreciated

JOB	MONTH	RESULT
1	JAN	10
2	FEB	15
3	NOV	11
4	DEC	35
5	NA	60
6	MAR	0
7	NA	0

[maxgro]

maybe

only({$ <MONTH+={NA}>} RESULT)

[Anonymous]

Thanks for your response,Actual data is NULL in the place of NA.Can you tweak that logic for NULL

[maxgro · Accepted solution]

only({ 1-<MONTH={*}>+<MONTH=P(MONTH)> } RESULT)