Hello,I have a SQL Table in the below structure and am trying to write a PIVOT Query to get the %contribution of Service Request Numbers by Warranty Type. Could anyone pls suggest how do i obtain this?

Help I need:1. How do I get just one row for one product (as for ex: Personal Notebooks is appearing 3times in the above output)2. Instead of getting the count – is it possible to get % of the column total....as in if I draw a pivot on excel below is the output – just wondering how do I convert the value of count to % of total of the respective column

Below is the excel output..(which I do in the excel pivot value field settings – show value as % of column total) which is the similar output i want thru a SQL Pivot query or any other means to acheive this in PIVOT...this query output is what am finally intending to use as a dataset in my SSRS Report.