- 三層指標(biāo)
L3 具體的值
L2 時(shí)間序列
L1
-
最終表樣
表頭樣式，從上到下L1-L3
可篩選
寫了三層嵌套
Abs val > Abs val 【L1】 > Abs val 【L2】
Period = IF(HASONEVALUE(L2[L2]),VALUES(L2[L2]))
Abs val LY = SWITCH([Measure],
"Val (000 RMB)",[Abs val value LY],
"Vol (Pack)",[Abs val pack LY],
"Vol (Unit)",[Abs val unit LY],
"Avg Price (Pack)",[Abs val avg pack LY],
"Avg Price (Unit)",[Abs val avg unit LY],
blank(),[Abs val value LY])
Abs val value LY = SWITCH([Period],
"L1M", [Val LY]/1000,
"L3M", [L3M LY]/1000,
"MAT", [MAT LY]/1000,
"YTD", [YTD LY]/1000,
blank(),[Val LY]/1000)
