In your original question, you posted two clustered indexes, which is not possible.
Which one is it?
Can you post the table DDL?
Some sample data is appreciated as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP