View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default pivot "fields per column" setting

If you have many page fields, you can arrange them in multiple columns
at the top of the pivot table, instead of all in one column. The 'Fields
per column' option sets the maximum number of page fields in each stack.


BorisS wrote:
Anyone know what the "fields per column" setting in pivot table options does?
And what's it good for? Thanks.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html