View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default 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