11 Replies Latest reply: Feb 3, 2014 8:38 AM by Srikanth P RSS

    Create a new tempary table form 3 tables

    tarun bisen

      Hi,

       

      Please help me for creating the new table from the 2 or 3 tables for the Calculation in the Pivot table.

       

      I want to Sum the Score Area wise in the pivot table

       

      Example:

       

      TABLE 1TABLE 2Header 3
      CustomerCustomerCustomer
      TypeTarget QuantityOutstanding amount
      QuantityMonthother feilds
      Area
      Invoice Amount
      Invoice Date
      many more feilds

       

      New table in script

       

      Temp Table

      TEMP TABLE
      Customer
      Actual Quantity (Total Quantity)
      Target
      Score    (... in this field the Condition (if(Actual Quantity/ Target)>=0.80,1,0)....)

       

      Example 2: