Quickie on Pivots

S

Soapydux

Is it possible to force a pivot table to display the column
information.

Instead if this format

Category 1 Apples
Pears
Grapes
Category 2 Nuts
Raisens



I want to display this instead

Category 1 Apples
Category 1 Pears
Category 1 Grapes
Category 2 Nuts
Category 2 Raisens

Thanks
 
K

Ken Wright

It's easy enough to add the data after it has been generated by the Pivot
table, but that usually involves breaking the Pivot table links though. Do
you need it to remain dynamic?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
D

Dave Breitenbach

I dont think there is a setting that does that. There has been many
occassions where I've had formulas read off a pivot table to compensate for
the lack of presentational ability in the pivot table. Even though the
getpivotdata function does not copy down, formula lookup can still work by
typing in the cell reference instead of linking dirctly to one of the cells
inside the table. In this manner you can convert the pivot table to any
format you want and remain dynamic. Usually I'll use cells to the right of
the pivot table, but its probably better to use another sheet in case the
width of your table needs to be dynamic as well.

hth,
Dave
 
Top