table 'AIA.Fields_MarketBrand'
	lineageTag: 7c85987c-78f5-435f-8eee-3316cc29fecb

	column 'AIA.Fields.MarketBrand'
		lineageTag: bef276eb-08a1-48ac-8e05-42251343dc36
		summarizeBy: none
		sourceColumn: [Value1]
		sortByColumn: 'AIA.Fields.MarketBrand Order'

		relatedColumnDetails
			groupByColumn: 'AIA.Fields.MarketBrand Fields'

		annotation SummarizationSetBy = Automatic

	column 'AIA.Fields.MarketBrand Fields'
		isHidden
		lineageTag: aab5bec5-47b9-4c78-a15d-7ad5dfa75c07
		summarizeBy: none
		sourceColumn: [Value2]
		sortByColumn: 'AIA.Fields.MarketBrand Order'

		extendedProperty ParameterMetadata =
				{
				  "version": 3,
				  "kind": 2
				}

		annotation SummarizationSetBy = Automatic

	column 'AIA.Fields.MarketBrand Order'
		isHidden
		formatString: 0
		lineageTag: dc6a7fd8-1a73-434d-8a4f-340815fe1591
		summarizeBy: sum
		sourceColumn: [Value3]

		annotation SummarizationSetBy = Automatic

	partition 'AIA.Fields_MarketBrand' = calculated
		mode: import
		source =
				{
				    // ("Rank", NAMEOF([External.Rank.KPI.Combo]), 1),
				    ("Sales", NAMEOF([External.Sales.KPI]), 2),
				    ("MS%", NAMEOF([External.MS%.KPI]), 3),
				    ("ΔMS%", NAMEOF([External.△MS%.KPI]), 4),
				    ("GR%", NAMEOF([External.Gr%.KPI]), 5),
				    ("EI", NAMEOF([External.EI.KPI]), 6),
				
				    ("Market Size", NAMEOF([External.Sales.KPI.Market]), 7),
				    ("Market Size LY", NAMEOF([External.Sales.LY.KPI.Market]), 8),
				    ("Market GR%", NAMEOF([External.Gr%.KPI.Market]), 9),
				
				    ("Incr. Sales", NAMEOF([External.GRSales.KPI]), 10),
				    ("Incr. Contr%", NAMEOF([External.GRSalesContr%.KPI]), 11),
				    ("QoQ GR%", NAMEOF([External.RQGR%.KPI]),12),
				    ("HoH GR%", NAMEOF([External.HoHGR%.KPI]),13),
				
				    ("Mole. GR%", NAMEOF([External.Gr%.KPI.Mol]), 14),
				    ("Share% in Mole", NAMEOF([External.MS%.KPI.Mol]), 15),
				    ("ΔShare% in Mole", NAMEOF([External.△MS%.KPI.Mol]), 16),
				    // ("Mole. Sales", NAMEOF([External.Sales.KPI.Mol]), 17),
				    // ("Sales LY", NAMEOF([External.Sales.LY.KPI]),18),
				    // ("ΔRank", NAMEOF([External.△MS%Rank.KPI.Combo]), 19),
				    ("Class. GR%", NAMEOF([External.Gr%.KPI.Class]), 20),
				    ("Share% in Class", NAMEOF([External.MS%.KPI.Class]), 21),
				    ("ΔShare% in Class", NAMEOF([External.△MS%.KPI.Class]), 22)
				}

	annotation PBI_Id = 50ed5c5b5bf744a194067575ea51a5e0