I have the following dataset:
Using Crystal Reports 2008 I want to group by Hierarchy and then Job and include summary totals in the group headers.
The difficulty is that the TotalBudget in each record is the total for Hierarchy and Job combination so should be displayed as is, not be summed, in the Job group header. I then want the sum of the Total Budget value displayed in the Job group header to be summed to the Hierarchy group header.
The Actual value for each record needs to be summed to the Job group header and the Hierarchy group header.
The output I need in the report is as follows. The left hand column is the section structure. Hopefully it makes sense.
Help would be greatly appreciated.