Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Pivot Report (for Blasts or Digs)

You may create Pivot type report for Blast or for Dig by choosing required option from Add Report dropdown.

Pivot table comes in really handy as a quick way to make an interactive summary from many records. Among other things, it can automatically sort and filter different subsets of data, count totals or calculate average. Another benefit of using pivot tables is that you can set up and change the structure of your summary table simply by dragging and dropping the source table's columns.

In the top right part of application you see the list of all project elements to work with, organised by levels or folders.

Drag and drop parameters to display in your custom report to related fields from the top right part of the Reports tab to the bottom one. They will be automatically displayed in the main viewport accordingly.


You may also customise right part form layout by pressing top right icon and selecting desired layout of areas and fields as shown below.

By default “Field Section and Areas Section Stacked” layout is set. You may change it at any time to suit your display preferences.


In a bottom part of this right section you see four areas where you can drag and drop required fields.

It has an automated sorting function preventing you from dropping wrong fields into wrong areas.

To remove a field from an area simply drag it out and drop in any spot where it is marked by the Black Cross sign.


You can always manually change the layout of your pivot table by dragging fields to the desired locations between existing columns.


Press the filter icon to open its dropdown and select options to display and organise them in your table.


Right click on the field header and untick/tick Showing Totals.


Press Configure Format button to open Configure Pivot Grid Appearance window where you may add more custom settings, such as text font, size, style, colors and format for each element of a table.


Press the Copy Image button to make a screenshot of your table, which will be copied to the clipboard and can be pasted directly to your reports or presentation.

  • No labels