Pivot Table: Show row labels in Grand Total

[smong]

Is there a way to show the row labels in an Excel 2010, Pivot Table Grand Total? For example, I have: sales for each SalesPerson and Month

Peter Sales
JAN: 15
FEB: 10
Susan
JAN: 18
FEB: 12
Grand Total 55

I would want JAN and FEB to repeat in the Grand Total, with 33 and 22 respectively.

 

[RoryA]

Right-click the Month field, choose Field settings, and set the subtotals to Sum rather than Automatic.

 

[smong]

Hi, it is already set at Sum, and each person's monthly sales are already correctly summed. However I would like the Grand Total to also include the sales by month from all sales persons. Instead the Grand Total just indicates the Total sales from all months. In other words, the Grand Total section does not include the row labels.

 

[RoryA]

Did you right-click the Month field or the Sales field? If you do it to the Month field, you should see Month totals added at the bottom.

 

[smong]

Got it, excellent. Thanks!

Oddly, the format is different from the rest of the table. I chose Compact View which displays the months below the sales person's name. However, for the Grand Total, the months are displayed above the grand total, and does not include the "+" to collapse. This is ok except that if the months for the last SalesPerson are collapsed (Susan's in this case), the Grand Total months are collapsed along with it... Strange.

 

[RoryA]

Yep - no way round that that I know of (happens in all layouts)