PDA

View Full Version : Pivot Table with both Compact & Classic Layouts



JimS
05-03-2012, 11:59 AM
Can a Pivot Table (Excel 2007) use both the Compact and Classic layouts together?

For example, I would like 3 or 4 pivot facts to be in the 1st Column, using Compact Form mode and then switch to the Classic Pivot Table Layout mode for the remaining pivot facts and pivot values.

I've attached an example of what I'm trying to do.

Thanks for any help or ideas...

JimS