Okay well I've been trying to figure this out. As of now here is main View for this project. It pulls all the values fine. Please look at the following...

Had some problems with the code you wrote for me. So I had to change a few things around. Please check out my next post and the picture with it.

Hey thanks alot. Havent learned and thing about Cross Tabs and Pivot Tables. I am checking you article out now 🙂

Thanks for the code. I will try it tommorow...

Awesome, so the Total Value works now.

Now I just need the Total Value and Quantity Purchased for Last Year , 3 Years , and 5 Years. Each in seperate columns...