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