Display total qty sold of each item of each store

That operation is called PIVOT. The report is of the cross tabulation type.

Here is an example for dynamic PIVOT (not simple):

http://ift.tt/1dKYASY

---

Kalman Toth Database & OLAP Architect SQL Server 2014 Design & Programming

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012