Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a limit to the number of fields (including calculated field) that I
can put into the data section on a pivot table? I have fields of Current, Over30, Over60, Over90, Over120 and Total. I'm trying to add calculated fields to calc the % of Total for each the Current, Over30, Over60 etc. All works fine until I get to the Over120%. The formula is fine but it doesn't show up on the pivot table. The only way I can get it to show is if I manually delete one of the other calculated fields. Figured it must be a limit - if so, is there any other way around it? -- Thanks, Dino |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
flattening aggregated fields in pivot table | Excel Discussion (Misc queries) | |||
Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
Pivot Table Cycling Through Page Fields Automatically | Excel Discussion (Misc queries) | |||
pivot table question, sum fields? | Excel Worksheet Functions | |||
Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions |