In most situations, Pivot Table can be sorted in the same way as other regular data tables (see how to make a simple Pivot Table):
Step 1: Move your mouse to the column which you want to sort and right click;
Step 2: Click "Sort" from the dialog box;
Step 3: Select "Sort Smallest to Largest" or "Sort Largest to Smallest" when working with numeric data;
– Select "Sort A to Z" or "Sort Z to A" when working with text data;
– Select "Sort Newest to Oldest" or "Sort Oldest Newest to Newest" when working with the date and time.
