Moving total column in pivot table

[MGT2000]

Good morning,

I'm wondering if there is a way to have my Grand Total column for rows display after the row labels column instead of the last column at the end of the row? Seeing the total next to the name in the row label makes it easier for some to read the report. I can copy and paste values then manipulate my columns but I lose the pivot table. Any help is appreciated,

Thank you

[Cheeky Charlie]

In this situation most people replicate the table alongside the pivot with simple =A1 type formulae copied across, of course this gives the opportunity to reorder columns at will - unfortunately it nullifies much of the flexibility that pivot tables are great for (too much IMO).

But anyway - that's a fix

HTH