Dimensions & Lookup
Been struggling on this particular piece:
We have a module where we have a Country Dimension and Serial Number list, as each country has a fixed number of 10 agents and some attributes (line items).
Agent Name & Agent Role are list formatted Line Items. "Country" and "No." are lists.
We want to avoid the "No." list and only show Country-Agent-Role. It was initially designed with fixed "No." list of 5, where countries may or may not have 5 agents, as in the case of Canada where they have just 3, while Asutralia as full 5.
I have already managed to get the country & agents using agent allocation formula however unable to get the role to this view.
Any suggestion/tip to solve this would be helpful. Thanks