Please help me to find a solution to the below
1. We have a mapping table name MWP and have columns Parent_vendor and plan_names.
2. The MWP table have only one parent_vendor named Modern .
3. We have another mapping table named Parent vendors table having all the parent_vendor names such as Modern and Dynamic.
2. The source for MWP is from an excel sheet.
3.The MWP is connected to the Parent vendors table thorugh parent vendor name.
4.The Parent vendors table is connected to another source named Globus through parent vendor names.They have common parent vendor names.
and values associated with each vendor.
5. A measure is created using Globus table's value net_sales.
We need to add another vendor named E3 to Parent vendors table which is a subgroup of Parent_vendor Modern and E3 is only for
few plans from Modern vendors plans.
and E3 is not available in Globus so we cant map the value in Globus.
And We cant add E3 to the MWP table.
And we need to show the matrix visual contains Parent vendors and their assoiciated globus value.
