You can use this tutorial to learn how to create Excel pivot tables: How to Create a Pivot Table Report with QlikView Data
I have attached the sample project in case you want to play around with it. Extract to folder C:\Temp\Community\073 or change the paths in the NSQ.
HTH - Daniel.
Proj073.zip 148.7 K