Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have loaded following fields from one qvd say T1: i.e.
T1:
Sales_Organization,
Product_Group,
month(TecoProxy) as TecoProxy ,
TecoProxy_Year,
Cat,
Consumption,
SWO_Count
Now i loaded one more table with the following fields:
T2:
Sales_Organization,
Product_Group,
[Norm Applicable Year] ,
Cat,
Consumption,
SWO_Count,
NORM
Now in second table i need only Norm to be in first table and i don't want Sales_Organization,Product_Group,[Norm Applicable Year] ,Cat,Consumption, SWO_Count from second table.
Norm is derived from based on year and it is not derived based on Month but when i add TecoProxy from first table in dimension then i am getting values for Norm for all the months which is wrong because since i don't have Norm at month level i need to get same values in chart. But instead of that i am getting different vales for month
Can you please help me how can we achieve it.
Attached app for more reference
Thanks,
Bharat
Can you use Lookup() function rather than join to avoid those entries ?
what is your expected output, w.r.t. sample data which you provided??
Regards