table 'AIA.Fields_Measures_All' lineageTag: 63039b35-24f4-4aa6-8df3-07065788e0a4 column 'AIA.Fields_Measures_All' lineageTag: 537fe04a-e764-49fd-b3ed-b2f5abc82240 summarizeBy: none sourceColumn: [Value1] sortByColumn: 'AIA.Fields_Measures_All Order' relatedColumnDetails groupByColumn: 'AIA.Fields_Measures_All Fields' annotation SummarizationSetBy = Automatic column 'AIA.Fields_Measures_All Fields' isHidden lineageTag: 99f86bea-1d71-4c15-91cb-8cbd56399438 summarizeBy: none sourceColumn: [Value2] sortByColumn: 'AIA.Fields_Measures_All Order' extendedProperty ParameterMetadata = { "version": 3, "kind": 2 } annotation SummarizationSetBy = Automatic column 'AIA.Fields_Measures_All Order' isHidden formatString: 0 lineageTag: 616c974b-82ea-4af9-8587-9d8b07210edd summarizeBy: sum sourceColumn: [Value3] annotation SummarizationSetBy = Automatic column Category lineageTag: c37f6d4f-51fd-4f4a-be70-7196a68db8cf summarizeBy: none sourceColumn: [Value4] sortByColumn: 'Category Order' annotation SummarizationSetBy = Automatic column 'Category Order' formatString: 0 lineageTag: 2402da93-850d-4db7-96e1-597977c0c207 summarizeBy: sum sourceColumn: [Value5] annotation SummarizationSetBy = Automatic partition 'AIA.Fields_Measures_All' = calculated mode: import source = { ("Market Size", NAMEOF([External.Sales.KPI.Market]), 1, "Sales", 1), ("Market Size LY", NAMEOF([External.Sales.LY.KPI.Market]), 1, "Sales", 1), ("Sales", NAMEOF([External.Sales.KPI]), 3, "Sales", 1), ("Sales LY", NAMEOF([External.Sales.LY.KPI]),4, "Sales", 1), ("Market GR%", NAMEOF([External.Gr%.KPI.Market]), 5, "Growth", 3), ("GR%", NAMEOF([External.Gr%.KPI]), 6, "Growth", 3), ("QoQ GR%", NAMEOF([External.RQGR%.KPI]),7,"Growth", 3), ("HoH GR%", NAMEOF([External.HoHGR%.KPI]),8,"Growth", 3), // ("R3M GR%", NAMEOF(),7), --pending // ("RM GR%", NAMEOF(),8), --pending ("MS%", NAMEOF([External.MS%.KPI]), 9, "Share", 2), ("ΔMS%", NAMEOF([External.△MS%.KPI]), 10, "Share", 2), ("EI", NAMEOF([External.EI.KPI]), 11, "Growth", 3), ("Mole. Sales", NAMEOF([External.Sales.KPI.Mol]), 14, "Sales", 1), ("Mole. Sales LY", NAMEOF([External.Sales.LY.KPI.Mol]), 15, "Sales", 1), ("Mole. GR%", NAMEOF([External.Gr%.KPI.Mol]), 16,"Growth", 3), ("Share% in Mole.", NAMEOF([External.MS%.KPI.Mol]), 17, "Share", 2), ("ΔShare% in Mole.", NAMEOF([External.△MS%.KPI.Mol]), 18, "Share", 2), // ("Rank", NAMEOF([External.Rank.KPI.Combo]), 19), // ("ΔRank", NAMEOF([External.△MS%Rank.KPI.Combo]), 20), ("Class Sales", NAMEOF([External.Sales.KPI.Class]), 23, "Sales", 1), ("Class Sales LY", NAMEOF([External.Sales.LY.KPI.Class]), 24, "Sales", 1), ("Class GR%", NAMEOF([External.Gr%.KPI.Class]), 25,"Growth", 3), ("Share% in Class", NAMEOF([External.MS%.KPI.Class]), 26, "Share", 2), ("ΔShare% in Class", NAMEOF([External.△MS%.KPI.Class]), 27, "Share", 2), ("Sales Contr%", NAMEOF([External.SalesContr%.KPI]), 28, "Sales", 1), ("Incr. Sales", NAMEOF([External.GRSales.KPI]), 29, "Sales", 1), ("Incr. Contr%", NAMEOF([External.GRSalesContr%.KPI]), 30, "Sales", 1), // ("Ins#", NAMEOF([Inst#]), 31, "Institution", 5), ("Price/Unit(RMB)", NAMEOF([External.PriceUnit.KPI]), 32, "Price", 6), ("Price/CU(RMB)", NAMEOF([External.PriceCU.KPI]), 33, "Price", 6), ("Top1 Brand", NAMEOF([External.MS%.KPI.Top1PlayerName.AIA]), 40, "TOP Brand", 7), ("Top1 Brand Sales", NAMEOF([External.Sales.KPI.Top1Player.AIA]), 41, "TOP Brand", 7), ("Top1 Brand GR%", NAMEOF([External.GR%.KPI.Top1Player.AIA]), 42, "TOP Brand", 7), ("Top1 Brand MS%", NAMEOF([External.MS%.KPI.Top1Player.AIA]), 43, "TOP Brand", 7), ("Top1 Brand ΔMS%", NAMEOF([External.△MS%.KPI.Top1Player.AIA]), 44, "TOP Brand", 7), ("Top2 Brand", NAMEOF([External.MS%.KPI.Top2PlayerName.AIA]), 45, "TOP Brand", 7), ("Top2 Brand Sales", NAMEOF([External.Sales.KPI.Top2Player.AIA]), 46, "TOP Brand", 7), ("Top2 Brand GR%", NAMEOF([External.GR%.KPI.Top2Player.AIA]), 47, "TOP Brand", 7), ("Top2 Brand MS%", NAMEOF([External.MS%.KPI.Top2Player.AIA]), 48, "TOP Brand", 7), ("Top2 Brand ΔMS%", NAMEOF([External.△MS%.KPI.Top2Player.AIA]), 49, "TOP Brand", 7), ("Top3 Brand", NAMEOF([External.MS%.KPI.Top3PlayerName.AIA]), 50, "TOP Brand", 7), ("Top3 Brand Sales", NAMEOF([External.Sales.KPI.Top3Player.AIA]), 51, "TOP Brand", 7), ("Top3 Brand GR%", NAMEOF([External.GR%.KPI.Top3Player.AIA]), 52, "TOP Brand", 7), ("Top3 Brand MS%", NAMEOF([External.MS%.KPI.Top3Player.AIA]), 53, "TOP Brand", 7), ("Top3 Brand ΔMS%", NAMEOF([External.△MS%.KPI.Top3Player.AIA]), 54, "TOP Brand", 7), ("Default Potential Market", NAMEOF([4.3 PotentialMarket_Default]), 80, "Potential", 10), ("Default Potential Type", NAMEOF([4.3 PotentialType_Default]), 81, "Potential", 10), ("Default Potential Value", NAMEOF([4.3 PotentialValue_Default]), 82, "Potential", 10), ("Potential Market", NAMEOF([4.3 PotentialMarket]), 83, "Potential", 10), ("Potential Type", NAMEOF([4.3 PotentialType]), 84, "Potential", 10), ("Potential Value", NAMEOF([4.3 PotentialValue]), 85, "Potential", 10), ("ㅤ", NAMEOF([Hidden Measure]), 1000, "Keep this check box", 100) } annotation PBI_Id = e07f6698bc3942ee9968d7b8bc3a8601