Oct 09 2019 05:06 AM
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.
Oct 10 2019 09:06 AM
Oct 11 2019 06:35 AM
If to build PivotTable from data model the "Calculated Field" shall be greyed out. Have no idea what it could be.
Oct 11 2019 06:57 AM
is it possible that you post the file so we can take a look?