Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot "fields per column" setting
Anyone know what the "fields per column" setting in pivot table options does?
And what's it good for? Thanks. -- Boris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
how do you select many fields in a pivot table to drag in "data"? | Excel Discussion (Misc queries) | |||
Can you spread Pivot Table "Value" Fields in seperate columns | Excel Discussion (Misc queries) | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions |