So far, we've created pivot tables by starting in Dynamics GP 2016 and sending information to Excel. We can also use Excel 2016 to pull data out of Dynamics GP. For our dashboard, we need some sales data and receivables totals. The sales data that we want exists as a Dynamics GP data connection. The receivables data connection doesn't contain quite what we need, so we'll have to adjust it.
Let's add a sales pivot table first. To create our sales pivot table, follow these steps:
Top Ten Customers.