E.g. case when metrictype='Actual' then showcolumns(1,3,4) when metrictype='Budget' then showcolumns(2,5,6) else showcolumns(all) end