Splitting row Grand Totals for Column Labels

[mikelee101]

Hello All,

I have a pivot table that tracks sales and returns within different branches. It is giving me row totals, but my preference would be that the Grand Totals show sales and returns separately. It seems like this used to be doable, but I can't find it any longer. I'm now on Office 2013, Win10 Pro.


PivotTable.PNG

Hopefully the attachment shows. If not, I have Branch as the top column label, and within each branch is Order Type. So each branch has a column labeled SO and a column labeled SR. I would like for the Grand Total column to be the same instead of simply a row total.

Any help anyone can give would be greatly appreciated.

Thanks.

[JeteMc]

My thoughts would be that you might be able to use calculated fields. If not then adding columns to the source data could be an option. It might help if you would upload a sample workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.