Yes, I have that set as all rows. I believe I stated my question incorrectly. I need the grand total for the columns which will be to the right of my numbers that I want the sum of.

Thanks!

I'm fairly new to using Analyzer. Where is the pivot settings located?

Thanks!