Pivot functions are used to aggregate specified conditions on the table. In this sample, we are going to make a list of the quantity of each resource, each item and each day as the material for the report of the scheduling results.
Go to the Table View and open the Operation table.
In this table, the main resource Inventory is not needed, therefore right-click on the cell which displays Inventory and select Filter, then !=. This process will take out the Inventory details from the table.
Right-click on the upper-left cell of the Operation table and select Display Settings to set the Pivot function parameters.
Go to the Pivot rows and enter “Resource” in the New data cell.
Click the Right Arrow icon beside the (1) data cell to Set the details of the pivot row.
Set the group key as Group by resource. Click on the blank cell in the Value column to update.
Choose the Group by resource and click Insert. Then press OK to exit.
Set also the Sort expression in an ascending order.
Choose the Value with ascending description.
To add another property, enter “Item” in the new data cell.
Click the Right Arrow icon, set the group key as Group by main item.
Key in Summary in the new data cell of the Pivot contents.
Click the Right Arrow icon, select (Operation) Production qty as the display content expression.
Return to the dialog of the Operation table display settings by clicking OK on all of the pop up tables. You will then see that pivot columns are now summarized on the horizontal axis.
Key in the word Date to aggregate using the date as base.
Click the Right Arrow icon, change the group key to Group by day (LET).
Select the month, day and time for the Label property.
Enter Qty in the pivot contents to aggregate the production quantity.
Click again the Right Arrow icon, select (Operation) Production qty as the Displayed content expression.
Close the property window. You will then see the complete list below aggregated with the production quantity of each resource, each item and each day.
Grouping can also be enabled if you want to aggregate some of the fields. In this sample, let’s get the aggregated level of the quantity of each customer and each item. Open the Order table and filter again the Inventory order.
Right-click on the top line Customer and select Grouping then, Sum. Repeat the same for the top line Item.
As a result, you will see the order quantities aggregate by customer, by item.
To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at http://lib.asprova.com/ (see 23. User Interface). You may also check Online Help to learn more about Pivot and Grouping.