How can I sort my pivot table by the values of a certain column. I want to do this just like I would with a regular excel table whereby I sort the values of the whole table according to one column. I tried using the pivot table sort button but it didn't produce the results.