2 Replies Latest reply: Feb 13, 2018 9:26 AM by Prashant Sangle RSS

    Link the tables

    Bharat Kishore

      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