Calculated field total in cross-tab
I have three fields on a Crystal report cross-tab, FieldA, FieldB and
FieldC. FieldC is a formula field, dividing FieldA by FieldB. Report is organized like this:
Item Month1 Month2 ...
FieldA FieldB FieldC
Item1 x y x/y
Total sum(x) sum(y) sum(x/y)
How can I get (sum(x)/sum(y)) instead of sum(x/y) in the totals section?
Any help would be greatly appreciated.