Thread: Pivot table # of fields

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" <dsd@contexturesXSPAM.com> wrote in message
news:4368AFCC.9080401@contexturesXSPAM.com...
> 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" <dsd@contexturesXSPAM.com> wrote in message
> news:4368AFCC.9080401@contexturesXSPAM.com...
>
>>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

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




"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:4368AFCC.9080401@contexturesXSPAM.com...
> 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" <dsd@contexturesXSPAM.com> wrote in message
> news:4368AFCC.9080401@contexturesXSPAM.com...
>
>>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