Is it possible to insert calculated rows between groups in a crosstab?

[Mark]

I am trying to build a Profit & Loss Statement using a crosstab and I have not been able to determine if I can insert calculated values between certain groups.  The first jpg shows an example of the data returned by my query.  The other jpg shows where I need to add custom calculations between certain groups. (This example does not show the mutliple monthly columns of the crosstab.)

For example: "Net Revenue" = Total of "Revenue" group - total of "Adjustment" group.

So, it is possible to insert rows between groups in a crosstab? Any help would be greatly appreciated.

Thanks,
Mark

[Peter]

Hello Mark,

Due to Telerik Reporting data driven nature, our suggestion is to set up the crosstab with all the required groups/rows. Then you can conditionally display the groups by setting up filters. You can use Expressions to set up group filters based on groups data. This way you can control the rows/groups visibility.
 
In order to inspect and alter the crosstab groups our suggestion is to use the Group Explorer.

Best wishes,
Peter
the Telerik team