Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sum two columns in a pivot table | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions |