I am trying to take subtotals off of certain Field Columns in a Pivot Table I am working with, however, it seems that the subtotal function in Excel 2007 is either all or nothing. Any way to turn subtotals off for a specific field?
Just to paint a picture, My pivot shows loan numbers as a row and then the data fields consist of balance, int. rate, variance and other some other stats. I need the balances subtotaled but I do not want the interest rates subtotaled.
Any help would be greatly appreciated.
Thanks, Alex
Bookmarks