A pivot table Field List does not contain this option:ValuesRow LabelsSortColumn Labels

It seems you are dealing with an issue related to the Pivot Table Field List in spreadsheet applications such as Microsoft Excel or Google Sheets. Let’s break down the potential solutions.

1. Check Pivot Table Setup

Ensure that your Pivot Table is correctly set up. If your data source or the range is not properly defined, certain options might not appear. Verify that you have selected the correct range of data.

2. Refresh the Pivot Table

Sometimes, simply refreshing the Pivot Table can help. Right-click on the Pivot Table and select "Refresh" to update the data.

3. Field List Visibility

Make sure the Field List is visible. If it is hidden, you can display it by selecting any cell within the Pivot Table, then go to "PivotTable Analyze" (or "Analyze" tab) and click "Field List."

4. Different View Modes

Check if you are in the correct view mode. Switch between "Compact," "Outline," and "Tabular" forms under the "Design" tab to see if the options become available.

5. Application Version

Ensure your application software is updated to the latest version. Sometimes older versions may lack functionalities that are present in the latest updates.

Conclusion

If the options still do not appear, consider recreating the Pivot Table from scratch. If the issue persists, seek advice from technical support forums or the application's help resources, as there may be software-specific bugs or issues at play.