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.
If to build PivotTable from data model the "Calculated Field" shall be greyed out. Have no idea what it could be.
is it possible that you post the file so we can take a look?