Exclude the Value

[#1]

Hi,

I am having the data table which has some hundreds of the Customer Code. now we want to elminate some of the customer code from the Data table . We would like to have text box like feild and user can provide the customer code which has to be excluded from the data table.

Is it possible to do the same???

Regards,XXX

[shumailh]

Hey XXX,

I was away that's why couldn't reply... yes you can display the truncated text... try making them bold. i mean change the font of x axis data to bold. I know this is something strange but it works for me...

Shumail

[#3]

Thanks Shumail ,

I will try that and update you

Hi Nick,

Thanks for your response

I have a doubt on the calculation you have done for excluding the selected values. As you have two columns as Code ,Exclusion code with same values and through Match and getfeildselcetion value you have excluded. But i am trying to do the same thing with the siongle column. Since our data is of huge size it is like we need to add one more column to exclude the values.

This is the code i am trying .. Please correct me if i am wrong.

=IF(match(CID,$(=GetFieldSelections(CID,',')))=0,CID)

Is it mandatory that we need two columns with different names or is there any functionality to achieve this.

Also what is the use of the Select Excluded. I have tried using the select excluded . but while exporting to excel the excluded value is also getting exported.

Regards,XXX

[#4]

Check my last attachment. There is an implementation with one field.

[#5]

Thanks for response Nick,

I have some doubt ...

In your first example when you select the excluded code then the other table data is getting displayed based on the exclusion/excluding the selected values.

Since it is not mandatory we need to exclude the values. So by default the value should get displayed in the table and when they choose the excluded values then table data should get changed accordingly.

I have tried the Search excluded Built in option. Can u please explain this functionlity if feasible.....

Regards,XXX