Sample Gross Profit Report Using Statistics

In the PK1 demonstration business unit, sample report PROFG - Gross Profit Analysis by Product Group is an example of how the statistics capability can be used in a financial tables report.

As well as columns showing net sales, cost of sales and so on, there is a column on this report that shows percentage contribution for each product group. To calculate percentage contribution, a row is defined that calculates the gross profit for all product groups. This is not printed on the report, but is used later by Financial Tables Columns to calculate the contribution for each product group as a percentage of the whole.

In Financial Table Rows, retrieve the Row Content Code PROFG and view row number 100.

You can see that this is a Statistics row type. This row is extracting information for product groups. The row is not printed because the Exclude from Printing option is set.

Using Statistic Rows in Financial Table Columns

In Financial Table Columns, retrieve Column Content Code PROFG and view column number 15.

This is a column type of Mathematics.

The calculation is defined on the Formula tab. Notice the Value Basis for the Second Column - Column 1 is set to Statistic. This means the value for the calculation is not taken from the current row, but from the last statistic row defined. So the contents of Column 11 are divided by the total of Column 1.

The contents of Column 1 represent the total for all product groups, as this was selected by the statistic row.