ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pivot "fields per column" setting (https://www.excelbanter.com/excel-programming/334483-pivot-fields-per-column-setting.html)

BorisS

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

Debra Dalgleish

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



All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com