Pivot Table Options 'Fields per column'
 

What does the 'Fields per column' option do in the Pivot Table Options
window? I've created a pivot table then changed this from the default of -0-
to another value but don't see a change in my pivot table.
--
Sincerely,
Gary Brown

Pivot Table Options 'Fields per column'
 

From: Excel Pivot Tables Recipe Book by Debra Dalgleish.
Publisher: apress - page 29

My interpretation is what she says is:
If you have several page fields then...
setting Fields per column to zero lists them in a single column or
setting Fields per row to zero lists them in a single row.
--
Jim Cone
Portland, Oregon USA



"Gary Brown"

wrote in message
What does the 'Fields per column' option do in the Pivot Table Options
window? I've created a pivot table then changed this from the default of -0-
to another value but don't see a change in my pivot table.
--
Sincerely,
Gary Brown