麻烦法。应该是有便捷的
A1{B1 = SLICEARRAY(REVERSEARRAY(SORTARRAY(split(B1[!0;!0],","))),1,1) || B1 = SLICEARRAY(REVERSEARRAY(SORTARRAY(split(B1[!0;!0],","))),2,2) || B1 = SLICEARRAY(REVERSEARRAY(SORTARRAY(split(B1[!0;!0],","))),3,3)}
SQLSERVER
SELECT TOP 3 * FROM TABLE ORDER BY 排序字段
MYSQL
SELECT * FROM TABLE ORDER BY 排序字段 LIMIT 3
在查询数据集里用sql对你选中的指标按公司维度排序,然后过滤序号为<=3