Forum Discussion
bardaguera
Oct 09, 2019Copper Contributor
Unable to edit calculate values in a PivotTable
I have a pivot table, created by my colleague; it includes calculated values, and I am unable to see its formulas.
The following steps were taken:
1) select cell in the pivot table;
2) click "Fields, Items & Sets" ( "PivotTable Analysis" on the ribbon);
3) choose "Calculated Field."
Here I expect to see existing calculating fields in the "Name" drop-down list.
DD list is empty.
As a workaround, I take a look at another excel-file with those values (excel-university.com/edit-pivottable-values) but faced the same problem.
3 Replies
- PascalKTeamIron Contributor
is it possible that you post the file so we can take a look?
- PascalKTeamIron ContributorMaybe Power Pivot was used to create the file? Probably best to ask your colleague
- SergeiBaklanDiamond Contributor
If to build PivotTable from data model the "Calculated Field" shall be greyed out. Have no idea what it could be.