I have a chart which displays as a straight table with a grand total as the top row. If I change the chart to a pivot table, the grand total disappears. The total settings in QV can be quite confusing, but I have checked every setting I can, without success. I have even checked against the settings in a very similar pivot table, which works fine. Sub-totals seem to work fine. Any advice from anyone to get the grand total back?