Do you know how I can sort the values of a pivot table with data in the value field?

if you click the value column in the pivot table visual, you will see a sort option

more details you can find in the QS user guide: Sorting Pivot Tables in Amazon QuickSight - Amazon QuickSight

image