Pivot Grids
Pivot Grid Excel Export
Pivot Grid Excel Export When you export the pivot table to Excel, it exports with all visible columns. The pivot column order is dependent on the order of columns on the grid, not the order of pivoted columns. See the example below. Support Contact ...
Persisted Grids
Persisted Grids Steps to create and save a Persisted Grid: Select your Parameters Apply Filters and Sorting Adding and Removing Columns on a Persisted Grid Moving columns Grouping/Pivoting Columns Sorting Columns Exporting a grid to Excel Saving a ...
Pivot Grid Collapsed Grouping View
Anterra has enhanced the Pivot Grid collapse functionality significantly. Below is a view of Margin Gain Erosion grouped by Division and Project Manager. Clicking on the check box to the left of “Collapse Pivot Table” creates a drill-through report! ...
Setting the Default Date for a Pivot Grid
Pivot Grids now support the ability to define the default date to show when visiting the grid, you can select from the following options when saving a grid. To get to the save grid area shown you must alter a grid so that the save icon in the top ...
Clearing Browser Cache if an Anterra Grid does not load
Overview of Browser Cache Clearing When a grid does not load or after certain AnterraBI™ software releases, some components in the software may require a browser cache clearing. Most browsers store the settings from our site in the temporary ...
Pivot Grid: AP Vendor Payment Grid
Version 25 Release NEW PIVOT GRID Purpose: Review invoices and payments by vendor over a range of dates. This grid replaces an SSRS Report with pivot grid technology. MENU ITEM: Finance > AP Status > AP Vendor Payment Inquiry (PG) REPORT SECURITY: ...
All Pivot Grids: Force refresh button added to update user entered information
Version 25 Release All pivot grids have had a new button added - 'Force Refresh.' The purpose of this button is to ensure the latest data appear in your pivot grids. EXAMPLE: project managers are busy entering forecasts for a month-end, and have ...
Pivot Grid Group Counts Added
Version 25 Release All pivot grids now show you the number of items for each pivot table group. In this example, the Margin Gain Erosion grid is grouping jobs by Division, then Project Manager. The General Construction division has 11 jobs, the ...
Anterra Pivot Grids
Contents Overview of Anterra Pivot Grids Steps to create and save a Anterra PivotGrid 1. Select your Parameters 2. Apply Filters and Sorting 3. Adding and Removing Columns on a Anterra PivotGrid 4. Moving columns 5. Grouping / Pivoting Columns 6. ...