
Building Dashboards with Microsoft Dynamics GP 2016
By :

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 dashboard by learning about:
In the next few of chapters...
Change the font size
Change margin width
Change background colour