pivot table calculation

umzsexythang

Board Regular
Joined
Jul 11, 2003
Messages
50
Hi

I am trying to insert a calculated field in the final column of my pivot table which subtracts column A from column B. I only seem to be able to insert a calculated field in the final row though.

Any ideas?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,009
Members
412,304
Latest member
citrus
Top