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
|TABLE 1||TABLE 2||Header 3|
|Type||Target Quantity||Outstanding amount|
|many more feilds|
New table in script
|Actual Quantity (Total Quantity)|
|Score (... in this field the Condition (if(Actual Quantity/ Target)>=0.80,1,0)....)|
(ooxml, embedded labels, table is Table1);
(ooxml, embedded labels, table is Table2);
if (Quantity - [TargetQuantity] >= 0.8, 1, 0) as Score,
Drop Tables Table1,Table2,TempTable;
I'm not sure I totally understand your problem. Could you explain more?
Why can you not do this in the pivot table expression rather than building a new table in the script?
I have tried in the pivot table but i am not getting what i want.
I want to total numer of customer who achievement is more than 80% in a particular Area
Without joining the two tables, in the pivot table you just need an expression like:
if (sum(Quantity) - [TargetQuantity] >= 0.8, 1, 0)
Depending if Quantity and TargetQuantity are unique values or not (depending on month...) you will need to change the expressión ( sum(TargetQuantity) instead of just TargetQuantity )
Hope that helps
Ok, I would still try to do this in the front end, otherwise you are limited by your dimensions that you have pre-calculated across.
What was your expression in the pivot and do you know why it did not work?
It would use a combination of count and aggr...