Too many rows or columns in pivot table

K

koneil

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?
 
Top