It would be great if you also provide table schema & sample data. Without schema & sample data, it is difficult to provide help.

Refer - http://dotnetbites.com/grand-total-pivot-sql-server and try to align as per your needs.