Triggering Expression Value in the field in to dimension
I have multiple Project ID in a string separated by a delimiter. For example:
We need all the Project IDs in different columns one project ID per column.So here,I have spitted this field using Subfield in 7 expressions(Each string contains 7 Project ID).Now the requirement is ,if we click on some project Number only one project number should be selected and same value should be set in the Project_ID field which contains all the project numbers.
But when I tried to select one value whole row is getting selected and all the Project ID are getting selected.
But I need every Project number in different Column not in row as following:
As shown above we have all the projects related to Customer:Deliver Channel with it in differnt columns. and as per our requirement when we select some Project only that should be selected not the other projects.