Description:
I have a document with a pivot table. When I want to manually sort one of my row fields by the data field containing the sum of values in the Data Field Options dialog, changing this has no effect. Nothing happens and there is no feedback. When I reopen the Data Field Options dialog for the row field, the sorting option just reverted from manual back to the descinding, as if the change never happened. This behavior is already described in bug #124012 from 2019, which also helped me find the workaround. I also included a screencast.

Steps to Reproduce:
1. Open the file I attached and navigate to the second tab with the pivot table.
2. Open the pivot table's properties.
3. Double click the "Categorie" row field to open the "Data Field" dialog.
4. Choose "Options..." there to open the "Data Field Options" dialog.
5. By default sorting will be set to "Ascending".
6. Change this to "Manual" and sort with "Sum - Kosten" instead of the default "Categorie".
7. Confirm this change several times so that all the option dialogs are closed.
8. Backtrack to the same "Data Field Options" dialog again and observe that the sorting is back to "Ascending" and sorting with "Categorie" again, as if nothing changed.
9. The workaround is to follow steps 1 to 6, but then change sorting to "Descending" from "Manual". Sort by "Sum - Kosten" will still be active, but is now greyed out. Then follow step 7 and observe that the change now does take effect.

Actual Results:
Sorting doesn't change.

Expected Results:
Manual sorting by the sum of values should take effect.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.4.6.2
Build ID: 40(Build:2)
CPU threads: 12; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: nl-NL (en_US.UTF-8); UI: en-US
Calc: threaded