Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Derived Columns in Pivot Table
Is it possible to have a column in Pivot table with values of this column derived from existing columns (like sum,product of values from two or more columns)? For example, I have column 1,2,3 and 1000 rows. Now, when I create a pivot table I list different values from column 1 as rows in pivot table and values from column 2 as my columns in pivot table. I get 10 rows (from column 1) and 4 columns (from column 2) in pivot table. Now I want to create third column in pivot table by adding values from first two columns of pivot table. Is there any other way to do this without pivot table? I like the fact that in pivot table I can double click on a cell and get all the data behind it in another worksheet. Jay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=510022 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot tables - inserting columns | Excel Worksheet Functions | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |