WrightZone Weighbridge Software Manual
Menu
Index
Search
 
   
   
   
 
 
← Previous page
 
Next page →
 
Copyright© WrightZone Limited 2016

Pivot Grids

Pivot Grids exist throughout the application offering users an ability

to turn large amounts of data into a compact report with easily manageable results that make a tight and succinct view. What makes it a powerful tool is that users can perform visual modeling of the reports structure by manually rearranging fields across different areas or within a particular zone or by hiding them in the customization form. Dragging a field or a group of fields around in the view will result in changing a report on the fly.
 
Users can quickly change orientation of the field from column to row, lining up fields in a particular header area, so the values of those fields are arranged in the related area into a hierarchical tree, thus the logically related data can be organized by categories. Having that tree in your report means users can drill down and up data at different levels. As a result users are empowered to perform deeper data analysis and/or avoid unnecessary clutter existing in the detail.
 
Pivot Grids
 
1

Filter Header Area

The Filter Header Area displays the headers of all the visible filter fields. The filter header area Separator borders this area from the rest of the grid control.
 
1. Filter Header Area
  • With field selection and right click the Filter Header Field Area Context Pop out is made available to users (below).
  • Hide will hide the field from view within the Header Area removing fields that are not applicable to the user or clutter their choice of field selection.
  • Order with Move to options are self explanatory offering users a choice of the default position for any field within the Header Area.
  • Show Field List reports any fields that may be set to hidden.
2

Filter Fields

Filter fields are located in the pivot grid's filter header area. Filter fields allow users to apply a filter to the entire PivotGrid control to display data for specific values. Users can specify the filter criteria using the filter dropdown window which is invoked by clicking the filter button. To further filter the data displayed within the data area, users can apply filter criteria to the field values of column fields and row fields.
 
2. Filter Fields
3

Filter Button

Filter buttons are displayed within field headers and can be clicked to invoke the filter dropdown window. This window allows users to filter the data by selecting the field values which will be included in the resulting data subset to calculate summaries.
3. Filter Button
 
 
4

Fields

A Field is a subset of data passed as a source from your WZWB database to a pivot grid. A field provides values that the pivot grid uses to build a report; create its layout, filter data, and calculate summaries.
 
4. Fields
 
In the pivot grid, a field is represented by a field header. All user operations with a field (such as layout customization, filtering and sorting data, etc) can be carried out using the corresponding field header.
 
 
Field Headers contain:
  • A caption string which identifies the field's content;
  • An image which provides graphical information about the field's content;
  • A sort glyph which identifies the sort order applied to the field's values;
  • A filter button which users can use to filter field values.
 
Headers of all the visible fields are contained within the following header areas:
5

Header Area

The Header area offers users all the fields available for selection with which to populate the content of your pivot grid.
 
5. Header Area
  • Users can invoke the Header Area Context Pop out Menu with right click within this area.
Show Field List opens the pivot grid customization form and offers a view of set hidden fields within your pivot grid. The Dispatch Grid has a few of these (below).
 
  • Users can now add hidden fields to any of the Filter, Row, Column or Data Areas with selection (click) of the applicable field then browsing the appropriate Area combo box and clicking the Add To button (above left).
 
Show Prefilter Dialog offers advanced grid customisation for any field using the grid filter builder functionality.
6

Data Header Area

The Data Header Area is defaulted and pre-populated based on common client requirements for each WZWB pivot grid, displaying user selected data header fields.
 
6. Data Header Area
  • For numeric data fields, functions of  Sum, Count, Minimum, Maximum, Average, will be delivered based on the grid your are enquiring on and for nonnumeric data fields, only the Count Summary function will exist.
  • Data fields represent fields which are located in the pivot grid's data header area. The PivotGrid calculates summaries against the data fields and the summary results are displayed within the data area.
  • Data cells, total cells and grand total cells are displayed in the data area.
7

Row Header Area

The Row Header Area is defaulted and pre-populated based on common client requirements for each WZWB pivot grid, displaying user selected row header fields.
 
7. Row Header Area
  • Row fields represent fields which are located in the pivot grid's row header area.
  • Row headers that correspond to the values of the row fields, subtotals and grand totals are displayed within the Row Area.
8

Column Header Area

The Column Header Area is defaulted and pre-populated based on common client requirements for each WZWB pivot grid, displaying user selected column header fields. 
 
8. Column Header Area
 
  • Column fields represent fields which are located in the pivot grid's column header area.
  • Column headers that correspond to the values of the column fields, subtotals and grand totals are displayed within the Column Area.
 
 
A pivot grid column header area that has more than one column field will have the innermost column field (Profit Centre, below) and any other column fields are referred to as outer column fields. Values of the outermost column field (Year, below) are displayed only once while values of the rest of the column fields can be repeated.
9

Data Area & Pop outs

Data Cells are located in the data area of the pivot grid. Data cells display Cross Cells, Total Cells and Grand Total Cells. Cross cells display summary values which have been calculated for row and column fields.
Each cross cell displays a summary calculated against a data field for a subset of records stored in your WZWB database. All records from this subset have matching values in a column fields and row fields and these values are identified by column and row headers.
 
9. Data Area & Pop outs
Pivot Grid Pop outs
There are multiple Pop outs accessed via right click within the pivot grid with options varied based on the fields existing within the Data, Row and Column Header sections of the grid.
All Pop outs should be self explanatory hence here we discuss the two most common employed by WZWB users.
  • Within both the Row Header and Column Header, Pop outs (above) are offered to users and values vary based on whether one or multiple Row Header fields or Column Header fields exist.
  • Collapse is singular and therefore on click will collapse the already expanded row or column header field, where the row or column is collapsed, Collapse is replaced with an Expand label and on click the single row or column is then expanded.
  • Expand All as with Collapse All (above) will expand or collapse all Row Header fields or Column Header fields into the innermost Row or Column Header field.
The Main Pop out (above) offers one further settings from that of the standard UI Pop outs being Hide/Show Total which delivers a functional option when looking at smaller data sets to remove subtotal values for the innermost Row Header field.