This content has been marked as final. Show 2 replies
I have loaded following fields from one qvd say T1: i.e.
month(TecoProxy) as TecoProxy ,
Now i loaded one more table with the following fields:
[Norm Applicable Year] ,
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