Show Grand Total in Pivot Table Rows

[JADownie]

Hello -

I have been using Pivot Tables for years, but today suddenly I am stumped!!

I am being asked to add a Grand Total column into the pivot to the right of Month. Nothing I have tried seems to work. I can't get the row grand total to even show up as the far right column.

What am I missing here now, and can this be done, or is there some sort of workaround?

Thanks!!!

 

[RoryA]

You can't put it to the right of month - it has to go at the end. Do you have grand totals for rows turned on in the layout?

 

[bryanrobson]

Hi RoryA. I didnt know that. Thats exactly what I want now. Perfect. I'm self taught, always learning something new.

Many thanks