回答:报表的「最父格」为 A2 单元格,选中 A2 单元格,选择「单元格元素>高级」,设置排列顺序为「升序」,输入公式:switch($$$,"XS",1,"S",2,"M",3,"L",4,"XL",5,"XXL",6)或者INDEX($$$,"XS","S","M","L","XL","XXL")。公式说明:$$$ 表示当前数据列switch 函数的作用是:当前值为 XS 则返回 1,当前值为 S 则返回 2,以此类推INDEX 函数的作用是:返回当前值在 "XS","S","M","L","XL","XXL" 序列中的位置最后按返回的数字大小进行排序