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!

Where is the pivot settings located in Analyzer?

Thanks!

Thanks for the quick response! How do I create All Member?