Because an indexed view is stored on disk, it must contain a clustered index (rather than a nonclustered one). Modify the index to make it a clustered index.
Submit feedback about this site to: