When value is 259 search in excel file

[Simon4]

Hi all,

I am working with a live database, in this database there is information about items and in which itemgroup they are. Old/unused  items are grouped in a group called "yet to be determend". Unfortunatly because of reasons I will not get into these items will never be categorized in the database.

To make a proper analysis I still categorized them in an external Excel file. 

Now I need the following solution:

When Itemgroupid=259 search In excel file for Itemcode and lookup Itemgroup. 

I made a simple script with the data I am using. 

How do I approach this problem?

Thank you kindly in advance,

Simon

[rubenmarin1]

That 'other' it's a configuration in the pie chart, you can disable to show that.

To check data it will be better to do in a table chart.

[rubenmarin1]

That would happen if the values of the Applymap() are not found in the mapping table, check wich values the excel have and in Appplyap use the field that matches those values from the database.

[Simon4]

Hi @rubenmarin1 ,

Thank you for all you time and patience.

After a lot of trying I have made it work. Could not have done it whitout your help.

Thanks lots,

SV