A Grid data group takes data from one data group in the DSD and transforms it into a grid of values based on values in specific columns and rows and accumulating numeric values from a specified field.

Select the data group whose data is to be transformed.

Select the fields to use as the column and row. For each you can specify the values you wish to use or if none is specified all values that are found are used.

For example, if in your grid you only want to include rows from the referenced data group that have a gender of “Male” or “Female” and ignore any other rows, enter the two values. Use the grab icon to the right to drag and drop the values into the sequence required.

Select the Value Field from the list provided. Only numeric fields may be selected as the value of each row will be accumulated by the column/row fields' values.

Finally, an optional Filter may be applied using the Function Builder. If specified, the function will be executed for each row in the referenced data group. Only those returning “true” will be included in the grid.