Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many rows or columns in pivot table
I have a data set from which I am making a pivot table. I wish the pivot
table to display the two separate columns from the database as "data" with subtotals. Yet when I place the two columns into the data section of the pivot table, I get an error: too many rows or columns in pivot table. I can easily put one of the columns into the pivot table column section and have the other as the data for the pivot table, but then I cannot (to my knowledge) get a subtotal from the each of the two columns, but only from the one listed explicitly as data. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-nested rows/columns in a pivot table? | Excel Discussion (Misc queries) | |||
Too many rows or columns in my pivot-table | Excel Discussion (Misc queries) | |||
Pivot Table - too many rows/columns error | Excel Discussion (Misc queries) | |||
pivot table - Can I pre-define rows and columns? | Excel Discussion (Misc queries) | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |