Custom Weighted Average Calculation for Crosstab Totals

Issue Description

Customer developed a crosstab report in Jaspersoft Studio.

Per report specifications, the crosstab totals should be calculated as custom weighted average function.

Resolution

Let's review a report based on SugarCRM sample database, ORDERS table.

The main idea is to manually add new measures, like:

• WeightSum - to calculate Summary on required field
• WeightedSum - to calculate average weighted by ShipVia with expression

$F{ShipVia} * $F{Freight}

The engine automatically creates variables for new measures which can be added to Crosstab Total columns.

Attached is a sample report that displays both a standard average of order freight and an average weighted by ShipVia.

Ref. Case 01466303

lateordersreport.jrxml