Hi,
I have a scenario like this:
Please find the attached qvw.
1 Combo Chart is Calculation is simple - Sum(Sales_Qty) = Actual
Sum(SOP_CTS) = Plan
Sum(Sales_Qty) - Sum(SOP_CTS) = vMAPE
This chart is displaying the data as 'per CATAGORY wise.
2nd Char is Group Level - MEELES is a group, where these are the Categories lies (stand alone). Total no. of category is 6 which belong to MEELES.
Down side graph I need vMAPE Calculation like - (Sum(Total vMAPE)/Sum(Total Actual)) * 100
Export 1 chart data to xls - (Sum(Total vMAPE) = 0.75
Sum(Total Actual)) - 4.70
= (0.75/4.70)*100 = 16.03
Same value i want in second chart - by selection of MEELES group - i.e - 16.03, But my current expression is giving me - 12.64.