Hello,
In my transactions list, I have a field called “Chain Simulate” which merges the dimensions “Ship Mode”, “Ship Mode Simulate” and “POL (code)” and returns as text property. Is there any way to merge the three dimensions and return in dimension property? The combinations are already created as a dimension in the background.
My purpose is to : Based on the combination in the column “Chain Simulate”, it should return a number in the Lead Time column. Besides, the Lead time per combination is added within a dimension & also created a mapping Metric.
Issues : I am able to merge & return the value only as a “Text” property so this text property cant perform a lookup to the below dimension or mapping. Kindly let me the know also best way to retrieve the Lead time based on the combination.
Dimenison :
Mapping Metric : ( This is pulling the data from above chain dimension)
Let me know if its clear or not.
Best answer by Mohan
View original
