A Pivot Table is a data summarisation tool that can automatically sort, provide totals or give the average of the data stored. A simple tip for Pivot Tables is to become familiar with the right-click menu (Remove Fields From Field Area is particularly useful). For a more detailed explanation of pivot tables in general visit: http://en.wikipedia.org/wiki/Pivot_table

Pivot Tables in the application are essentially no different to a regular Pivot table, but it's still useful to discuss the basic concepts of their use in the application.

• Summation Values: Called the Data Area in Micromine Spry. Can use any numeric Variable including Value Type Custom Fields including Volumes, Distances, Times, Rates etc.
• Row and Column Labels: Called the Row and Column Area in Micromine Spry. Can use any text or date Variable Filter Type Custom Fields including Leaf Positions, Process, Equipment, Reporting Periods etc.

You can also use multiple types of filters to show or remove anything in each individual Pivot Table. See: Filter Editor

Empty Row and Column Labels

One important feature to be aware of in Pivot Tables is that there are times when your row and column labels will be empty. Let's say you created a monthly Reporting Period, but only covered the first year and used it as your Row Label. Any summation value that falls outside the Reporting Period appears as a blank like the screenshot below.

In the example above it's a consequence of a Reporting Period setting (which can be resolved by recreating or amending the Reporting Period to include more periods) but an example where this feature can be particularly useful is during destination scheduling where you can use it to check your dump balance.

Finally, if you haven't used Pivot Tables before it's quite possible to create nonsensical reports with too many columns and/or rows. Don't worry! With a little patience you'll get the hang of it.