I am using Crystal XI, I want to do create summary data in various hierarchy groups I have in report. Unfortunately the data in details can be the same for each record sometimes so I have to do my first grup summary on maximum. But how do I then do summaries on that maximum
eg
records shift length
Hier 2 16 ? need this to be 500
Hier 1 6 100 (Max)
detail 1 1 100
detail 2 2 100
detail 3 3 100
... Hier 1 10 400 (Max)
You cant seem to sum the maximums? but I need to. Whats the solution, for instance could I just show the first value of 100 somehow and then I could do simple summations in each group as normal? Any other ideas welcome
eg
records shift length
Hier 2 16 ? need this to be 500
Hier 1 6 100 (Max)
detail 1 1 100
detail 2 2 100
detail 3 3 100
... Hier 1 10 400 (Max)
You cant seem to sum the maximums? but I need to. Whats the solution, for instance could I just show the first value of 100 somehow and then I could do simple summations in each group as normal? Any other ideas welcome