Create a new tempary table form 3 tables

[tabisen1]

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 1	TABLE 2	Header 3
Customer	Customer	Customer
Type	Target Quantity	Outstanding amount
Quantity	Month	other 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:

[tabisen1]

Dear

[#3]

Hi Tarun, Use Rangesum in the Sum of Score column

Please find the attached qvw.