Pivot Tables: General Information

In MYOB Acumatica, you can use pivot tables to reorganize and summarize data from generic inquiries.

Learning Objectives

In this chapter, you will learn how to do the following:

  • Configure a pivot table on an inquiry form and share it with other users
  • Modify the generic inquiry that is used as the basis for a pivot table while you are configuring the table

Applicable Scenarios

You may find the information in this chapter useful when you are responsible for the customization of MYOB Acumatica in your company, including developing and modifying generic inquiries and pivot tables to give users information they need to do their jobs, and you need to deliver inquiries and reports that your colleagues can use to perform their jobs effectively.

Pivot Table Basis

You use the data from a particular generic inquiry to compose a pivot table—that is, a generic inquiry is used as the basis of a pivot table. You can use only one generic inquiry to build each pivot table. If you need to compose a pivot table with information obtained from multiple generic inquiries, you must first create a single generic inquiry that includes all the necessary data and then use this inquiry as a basis for the pivot table.

Pivot Tables in Modern UI

In the Modern UI, you can effortlessly toggle between the table and pivot data representations of generic inquiry forms. Pivot views support in-depth analysis of information from multiple perspectives, enhancing your ability to make informed decisions.

Moreover, new pivot table views are separated from the filters functionality. That is, now you can apply the same filter both to table and pivot data representations.

By default, generic inquiry forms display data in the Table view. If other data views are available, they’ll be listed in the View List drop-down menu, where you can choose another data representation. The menu caption changes to the name of the selected view, as you can see below.

Figure 1. Pivot data representation


You can create your own pivot views, as explained below, or use pivot views created by other users.