Add New Column that query data from another table based on Slicer selection

Hi Ashish_Mathur ,

Thank you for the reply. Please find the following details:

Schedule Table:

Profile Table:

I have schedule table which show the production schedule of model and profile table which store the part no for each model. Because each model have a few part no and each part no production line only require to see relevant part no. Hence, based on user selection of profile with the slicer, I want to show only the selected part no to the user.

Example:

When I choose 'Carton Box' from my slicer, it should query my profile table for the part no for each model no from my schedule table and add new column of part no for carton box only into my schedule table.

Hope it clarifies. Thank you.

Regards.

Jenas