Adding columns in Pivot Table having coomon description
 

Hi,

I have made a Pivot Table (with 4000 rows and 80 columns) giving
details of Employee Expenses for 2005-06 but it has columns which have
similar description since we changed the Account Codes during the year
and in some cases they mean the same thing like Breakfast, Lunch and
Dinner all of which can be merged in one column.

Is there a way these similar columns could be added into one column
within the pivot table itself?

Thanks in advance,

Sayvari


--
sayvari
------------------------------------------------------------------------
sayvari's Profile: http://www.excelforum.com/member.php...fo&userid=7402
View this thread: http://www.excelforum.com/showthread...hreadid=532351

Adding columns in Pivot Table having common description
 

You're wanting to add three fields (columns) together to arrive at a
fourth field (column).

This can be done in your datatable, or as you're suggesting can be done
within the pivottable itself. This new field is called a calculated
field. Refer:

http://contextures.com/xlPivot10.html


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532351