format(100.0* sum(case when status = 'Cancelled' then 1 else 0 end) ...
Query optimizer doesn't consider the index in the execution plan for any Transact-SQL statements. For more information about filtered indexes, see Create filtered indexes and the SQL Server index ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results