Please find the attached QlikView document. Scenario is like this :
Selection Parameter - Year-->2014 --> OGC --> JAN --> Type --> Uncertified
Down side Group wise vMAPE % and Accuracy % Chart is available, So please select Meeles from there.
Now Export the Data to xls of Upper Chart, i.e - (Plan v/s Actual) & VMAPE-Category wise.
Now - Make a calculation in xls = Sum(VMAPE) --> 0.75 and Sum(Actual) --> 4.70, Then (Sum(VMAPE) / Sum(Actual)) * 100 = (0.75 / 4.70) = 16.03
The same figure I need in down side graph, i.e Group wise vMAPE % and Accuracy %. Here calculation is like = What have formula is upper side for vMAPE, (vMAPE / Sum(Actual)) * 100.
Field Name - Actual is SALES_QTY and PLAN = SOP_cts
