年份选择历史年,月份默认当月,当我选择季度时,清空月筛选器和年度筛选器,数据集筛选的是该季度的最后一个月份,当我选择年度的时候(上半年和下半年),清空月筛选器和季度筛选器,筛选的是该年度最后一个月。如果年份是当年,月份为当月,筛选器逻辑跟之前一样,但是选择年度的时候就是10月份,选择季度也是10月份,这种判断在数据集里面怎么写?目前我只写了一段IF(LEN($年度)=0,IF($年=YEAR(TODAY()),"and fmonth='"+SWITCH($年度,"上半年","06","下半年",$月,"",$月)+"'" ,"and fmonth='"+SWITCH($年度,"上半年","06","下半年","12","",$月)+"'") , IF($年=YEAR(TODAY()) ,"and fmonth='"+SWITCH($季度,"Q1","03","Q2","06","Q3","09","Q4",$月,"",$月)+"'", "and fmonth='"+SWITCH($季度,"Q1","03","Q2","06","Q3","09","Q4","12","",$月)+"'"))