| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table with more than 3 columns
As far as I have understand from pivot table, it summarizes data of a single
list (database) comprising of 3 columns. Suppose that we have more than 3 columns, ex 5 colmns. Is it possible to make a single pivot table for whole 5 columns. In other words, is it possible that one category pf a pivot table be an array with 3 columns? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table with more than 3 columns
I see no one answered this question - its also not quite clear to me what you
are asking. However, a pivottable can be made from one or more lists and in Excel 2003 there can be up to 255 columns of data in the data source. -- Thanks, Shane Devenshire "Rasoul Khoshravan" wrote: As far as I have understand from pivot table, it summarizes data of a single list (database) comprising of 3 columns. Suppose that we have more than 3 columns, ex 5 colmns. Is it possible to make a single pivot table for whole 5 columns. In other words, is it possible that one category pf a pivot table be an array with 3 columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table with added columns for evaluating results | Excel Worksheet Functions | |||
| Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
| Grouping data in pivot table columns | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
