This appears to be the SUM in the total formula. Since the data is grouped on the Fahrzeug row it creates a group Scope within the Crosstab and the calculations values would use the same formula.
This means that the group total value isn't grouped and would calculate the value containing the whole data set. In contrast, the subtotal group calculates the value over each group.
For the total, the formula would be like the following.
[= MAX(Fields.Mileage) - MIN(Fields.Mileage)]
Alternatively, this could be quickly achieved using the Crosstab Wizard. Let me provide a visual guide below.
Step 1: Select the data source.
Step 2: Arrange the Fields
Step 3: Select the Subtotal/Total Layout
For reference, I have also attached a sample report.
Please let me know if you need any additional information. Thank you.
Eric R | Technical Support Engineer
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items