The sort order field lets you tell Excel whether and how you want to sort the result. Using this argument really highlights why the GROUPBY function can be more useful than using a pivot table ...

Here’s how it works: Import data tables into the Power Pivot data model from Excel or external sources ... the RELATED function, and measures, you can uncover insights that were previously ...

This should display 'Purpose of UK resident's visits abroad by month ... are hugely important when it comes to cleaning data for use in pivot tables. Now, select the data. Using Excel, this is as ...