O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating pivot tables from GP 2016 data connections

One problem with creating a pivot table from data in Excel 2016 is that we have to bring the data from Dynamics GP 2016 into Microsoft Excel. That's not much of a burden when we're dealing with a few hundred rows, but when you get to transactional data, it's easy to have a couple of hundred thousand rows. This is where pivot table performance starts to bog down. For companies with a lot of accounts, high transaction volume, and a lot of history, it's easy to exceed Excel's maximum row count of 1,048,576 rows. Microsoft Excel 2016 lets us build pivot tables without having to bring the data into Excel.

When we deployed Dynamics GP 2016's Excel reports, we also deployed the data connectors. The connectors ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required