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

Chapter 3. Pivot Tables – The Basic Building Blocks

Pivot tables are the basic building blocks of analysis in Excel. The same concept of establishing the pivot table elements, that is, Rows (required), Values (required), Columns (optional), and Filters (optional), are used within most of the Microsoft-reporting tools. Very often, I am asked how someone can make a pivot table look like a report and not like a table. With a few clicks of the mouse, your pivot table can become a professional, easy-to-read report.

At their most complex, these tables provide infinite ways to analyze and visualize data. We can't fit an infinite number of ways in this book, so we'll use some common scenarios here.

In this chapter, we will start building our Dynamics GP ...

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