How to use SWITCH function when using table for Matrix Header

[Baba]

Hello,

Can someone help me fix this issue?

I am using table for Matrix column headers and SWITCH function to bring the values but not able to find a way to bring very last column values because of # 11 (in the SWITCH function snip below).  Is there anyway to tell SWITCH if number is not equal to # 11 and 12? or only bring values if ">=6 and <=10"?

Thanks

[PhilipTreacy · Accepted solution]

Hi @Baba 

Try this in your SWITCH

DisplayItem >= 6 && DisplayItem <=10, RESULT

Regards

Phil