thanks Newbie. I removed nvarchar field(T.Name) from group by area. Now, the performance is good compare to previous one.

Thanks your reply. I created the view and try to create the index but i am getting the below error.

"The CREATE UNIQUE INDEX statement terminated because a duplicate key was...