70 lines
2.2 KiB
Plaintext
70 lines
2.2 KiB
Plaintext
table 'MarketGeo Val'
|
|
lineageTag: 21d9eb87-a385-4f14-b8e8-d82c7475d068
|
|
|
|
column val
|
|
lineageTag: 2f70ab49-b039-4e68-a676-72a93924da33
|
|
summarizeBy: none
|
|
sourceColumn: [Value1]
|
|
sortByColumn: 'val 个订单'
|
|
|
|
relatedColumnDetails
|
|
groupByColumn: 'val 个字段'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'val 个字段'
|
|
isHidden
|
|
lineageTag: e132191b-c455-4f5b-bcff-9de21ceb8d18
|
|
summarizeBy: none
|
|
sourceColumn: [Value2]
|
|
sortByColumn: 'val 个订单'
|
|
|
|
extendedProperty ParameterMetadata =
|
|
{
|
|
"version": 3,
|
|
"kind": 2
|
|
}
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column 'val 个订单'
|
|
isHidden
|
|
formatString: 0
|
|
lineageTag: 4a958075-9a9e-4d9a-b4dd-f8f08651596c
|
|
summarizeBy: sum
|
|
sourceColumn: [Value3]
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition 'MarketGeo Val' = calculated
|
|
mode: import
|
|
source =
|
|
{
|
|
("Rank", NAMEOF([External.Rank.KPI.Combo]), 1),
|
|
("Sales", NAMEOF([External.Sales.KPI]), 2),
|
|
("Sales LY", NAMEOF([External.Sales.LY.KPI]),3),
|
|
("Market Size", NAMEOF([External.Sales.KPI.Market]), 4),
|
|
("Market Size LY", NAMEOF([External.Sales.LY.KPI.Market]), 5),
|
|
("MS%", NAMEOF([External.MS%.KPI]), 6),
|
|
("ΔMS%", NAMEOF([External.△MS%.KPI]), 7),
|
|
("Market GR%", NAMEOF([External.Gr%.KPI.Market]), 8),
|
|
("GR%", NAMEOF([External.Gr%.KPI]), 9),
|
|
("QoQ GR%", NAMEOF([External.RQGR%.KPI]),10),
|
|
("HoH GR%", NAMEOF([External.HoHGR%.KPI]),11),
|
|
("EI", NAMEOF([External.EI.KPI]), 12),
|
|
("Incr. Sales", NAMEOF([External.GRSales.KPI]), 13),
|
|
("Incr. Contr%", NAMEOF([External.GRSalesContr%.KPI]), 14),
|
|
("Mole. Sales", NAMEOF([External.Sales.KPI.Mol]), 15),
|
|
("Mole. GR%", NAMEOF([External.Gr%.KPI.Mol]), 16),
|
|
("Share% in Mole", NAMEOF([External.MS%.KPI.Mol]), 17),
|
|
("ΔShare% in Mole", NAMEOF([External.△MS%.KPI.Mol]), 18),
|
|
("ΔRank", NAMEOF([External.△MS%Rank.KPI.Combo]), 19),
|
|
("Share% in Class", NAMEOF([External.MS%.KPI.Class]), 20),
|
|
("ΔShare% in Class", NAMEOF([External.△MS%.KPI.Class]), 21)
|
|
}
|
|
|
|
annotation PBI_Id = 7b01ebceebee46e6b63e247b01c6556f
|
|
|
|
annotation TabularEditor_TableGroup = 01_ParameterField
|
|
|