Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Dear
Hi Tarun, Use Rangesum in the Sum of Score column
Please find the attached qvw.