Please check "Quality Perfo Dashboard-Yearly " excel tab. I do not have these dimensions there and i want the output on the basis of this particular tab .
Data: First 2 LOAD "VLS Global", F2 as [NOK parts in customer database - total_Apr], F3 as [Real NOK parts manufactured - total_Apr], F4 as [Number of official Written concern_Apr], F5 as [Total number Alert + Written concern_Apr], F6 as [Volumes shipped (external sales only)_Apr], F7 as [NOK parts in customer database - total_May], F8 as [Real NOK parts manufactured - total_May], F9 as [Number of official Written concern_May], F10 as [Total number Alert + Written concern_May], F11 as [Volumes shipped (external sales only)_May], F12 as [NOK parts in customer database - total_Jun], F13 as [Real NOK parts manufactured - total_Jun], F14 as [Number of official Written concern_Jun], F15 as [Total number Alert + Written concern_Jun], F16 as [Volumes shipped (external sales only)_Jun], F17 as [NOK parts in customer database - total_Jul], F18 as [Real NOK parts manufactured - total_Jul], F19 as [Number of official Written concern_Jul], F20 as [Total number Alert + Written concern_Jul], F21 as [Volumes shipped (external sales only)_Jul], F22 as [NOK parts in customer database - total_Aug], F23 as [Real NOK parts manufactured - total_Aug], F24 as [Number of official Written concern_Aug], F25 as [Total number Alert + Written concern_Aug], F26 as [Volumes shipped (external sales only)_Aug], F27 as [NOK parts in customer database - total_Sep], F28 as [Real NOK parts manufactured - total_Sep], F29 as [Number of official Written concern_Sep], F30 as [Total number Alert + Written concern_Sep], F31 as [Volumes shipped (external sales only)_Sep], F32 as [NOK parts in customer database - total_Oct], F33 as [Real NOK parts manufactured - total_Oct], F34 as [Number of official Written concern_Oct], F35 as [Total number Alert + Written concern_Oct], F36 as [Volumes shipped (external sales only)_Oct], F37 as [NOK parts in customer database - total_Nov], F38 as [Real NOK parts manufactured - total_Nov], F39 as [Number of official Written concern_Nov], F40 as [Total number Alert + Written concern_Nov], F41 as [Volumes shipped (external sales only)_Nov], F42 as [NOK parts in customer database - total_Dec], F43 as [Real NOK parts manufactured - total_Dec], F44 as [Number of official Written concern_Dec], F45 as [Total number Alert + Written concern_Dec], F46 as [Volumes shipped (external sales only)_Dec], F47 as [NOK parts in customer database - total_Jan], F48 as [Real NOK parts manufactured - total_Jan], F49 as [Number of official Written concern_Jan], F50 as [Total number Alert + Written concern_Jan], F51 as [Volumes shipped (external sales only)_Jan], F52 as [NOK parts in customer database - total_Feb], F53 as [Real NOK parts manufactured - total_Feb], F54 as [Number of official Written concern_Feb], F55 as [Total number Alert + Written concern_Feb], F56 as [Volumes shipped (external sales only)_Feb], F57 as [NOK parts in customer database - total_Mar], F58 as [Real NOK parts manufactured - total_Mar], F59 as [Number of official Written concern_Mar], F60 as [Total number Alert + Written concern_Mar], F61 as [Volumes shipped (external sales only)_Mar] FROM [lib://Temp_Dhiloj_Request (varpwqlkdev1_visguest)/ZZ Global January 2019.xlsx] (ooxml, embedded labels, table is [Quality Perfo Dashboard-Yearly ], filters (
Remove(Row, Pos(Top, 2))
)) where "VLS Global"= 'TOTAL ACTUAL' ;
store * from Data into [lib://Temp_Dhiloj_Request (varpwqlkdev1_visguest)/Data.qvd](qvd);
( [Number of official Written concern_Mar]/[Volumes shipped (external sales only)_Mar])*1000000000 ) as Official_Customer_IPB_Mar , //Site Performace IPB
