Pivot table # of fields

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

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?
 
Thank you Debra. It's obviously something else making this field not show
up. I'll try again.
 
What version of Excel are you using? Does it look like you haven't
surpassed any of the limits?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table Calculated field error 1
XL2007 - Pivot Table Limitations 2
Pivot table formulas 1
Pivot table grand total location 1
Calculates field in pivot table 2
Pivot Table Calculated Field - Sum/count 1
How do I perform extended calculations in a Pivot Table in Excel 2 4

Back
Top