how to restrict a filed data??

[sushil353]

Hi All,

I have a field named Defect_type in which many type of defects are listed, but i need to take only two type of defect say NDR and NDF

I want to display only NDR and NDF in Defect_type field and all other defects should not affect my charts and reports.....

Suppose i have a chart to show unit processed according to NDR or NDF then the unit processed should be for NDR or NDF only

please help me out....

Thanks

[#2]

On any Chart,

go to Used dimension. Select the 'Defect_type' field dimension and Click on 'Edit'. There you type the following if condition:

=if(Defect_type='NDR' of Defect_type='NDF',Defect_type).

And finally, select 'Supress When Value is Null' on the 'Setting for Selected Dimensions' area.

Regards.