Can't seem to add field at end of pivot table

[GeneAlex]

Hello everyone. I am new to this forum, but have been hacking away at Excel for a long time. I never really became proficient, but just use it enough to get frustrated whenever I try to do something that requires a little more than basic knowledge. Having said that, I have a workbook for all of my financial data, and am creating pivot tables from the main data sheet. I would like to add a field to the expense categories pivot table that shows the average monthly expense for each category for the last 6 months. The table I created shows the GrandTotal, and I thought I could just divide that by the # of months for the average, but this seems to be a little more difficult than it should be. I am trying the use the 'Insert Field Calculator' as described in several online tutorials, but it doesn't seem to work. For one the the 'GrandTotal' field does not show up in the 'Fields' menu.

https://drive.google.com/file/d/1wh5rbhsYm1NKHj0SE5wTOjgWChu1F6aB/view
https://drive.google.com/file/d/1R5xMTlV_QHoOSs5PmTgs30WsMnh0Qla2/view

 

[Panda514]

Hello,

Since the GrandTotal field does not show up in the field menu (because it is not a field in your dataset), instead of adding in a field just add in a column right next to the end of your pivot table.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Field 1[/TD]
[TD]Grand Total[/TD]
[TD]Avg. Monthly Expense[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]B2[/TD]
[TD]=B2/12[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]B3[/TD]
[TD]=B3/12[/TD]
[/TR]
</tbody>[/TABLE]