1) I have 2 fields in the Row section of the Pivot Table. Is there a way to
set it up so you don't have a total at the end of each value change in the
first field of the row section? I dont want any subtotals totals; just the
grand total.

2) Is there a way to tell the pivot table that on the columns not show the
blank or empty columns?

Thank you for your help,

Steven