hi all,
I need to draw a graph by groups
one group is all types
another group is type A
another group is type B
the graph should be like
All types(sum of type A and B) type A type B
I tried to use "specified group" but this approach wouldn't draw graphs for type A and type B, since All types condition include evertyihg.
Your any help is appreciated
Thanks,
I don't think you can do this in Crystal. I recently needed to do something similar and ended up using a Command where you union your group data with Total data. eg
select GroupField, suM(amountField) as Total
Group by GroupField
Union all
selct 'All_Group', suM(amountField)
Ian
Add a comment