How do I get rid of the top "Grand Total" header? I don't want this label at the top. When I chose to hide column totals is doesn't do anything. It doesn't get rid of the header nor when I ask to display columns totals I don't get the totals. Does that menu option work?
The "Grand Total" head shows up if you have no columns defined in your pivot grid. Its purpose is to indicate that all of the 'columns' are totals and not true column values. You can see the 'Grand Total' disappear if you add 1 or more columns.
Currently there is no way to remove this.