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

The following MSKB articles outline PivotTable limitations for different
versions of Excel:

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel (2002-2003)
http://support.microsoft.com/default.aspx?id=820742

Dino wrote:
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?



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

Thank you Debra. It's obviously something else making this field not show
up. I'll try again.




"Debra Dalgleish" wrote in message
...
The following MSKB articles outline PivotTable limitations for different
versions of Excel:

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel (2002-2003)
http://support.microsoft.com/default.aspx?id=820742

Dino wrote:
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?



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

What version of Excel are you using? Does it look like you haven't
surpassed any of the limits?

Dino wrote:
Thank you Debra. It's obviously something else making this field not show
up. I'll try again.




"Debra Dalgleish" wrote in message
...

The following MSKB articles outline PivotTable limitations for different
versions of Excel:

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel (2002-2003)
http://support.microsoft.com/default.aspx?id=820742

Dino wrote:

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?



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






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