ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   inserting a calculated field in a pivot table. (https://www.excelbanter.com/excel-discussion-misc-queries/226847-inserting-calculated-field-pivot-table.html)

john b

inserting a calculated field in a pivot table.
 
I can't enter a calucated field for some reason in my pivot table. I have
about 20 or so data points populating my table and I want to calculate some
percentages with those fields but it's not creating another line. I can enter
the formula once i select insert calculated item and I can name the new line
but when i hit ok nothing is happening. When i usually enter formulas it asks
me if i want to replace the contents of the destination fieldand then
proceeds to insert another line but nothing is happening here. Could it be
that I have too many data points? Any help would be appreciated. Thanks


All times are GMT +1. The time now is 12:18 PM.

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