Hello, I have been trying to figure out how to add a total column to a pivot table where you have 2 items in the rows and then a bunch of items in the values section. It doesnt automatically total but was wondering if I could add a total to the actual pivot table, and not "copy/paste special", then add a SUM total. A picture of my field settings is below. I want to add a total in the sense of that total is apart of the pivot table and if someone double clicked, it would open a sheet with those total like a normal table.

Can anyone help out?



excelpivot.pdf