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:

Group1: Buyer
    Group2: Destination
        Cross-tab:

        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.

u cannot have two diff., formulas one for details and one for sumamry in crosstab. all u can do is create another cross tab with ur desired dormula and place it over the existing on and format accordingly to supress what u don't want to see in both the crosstabs.

http://support.businessobjects.com/l...s/c2006237.asp

it is possible with GridRowColumnValue and CurrentFieldValue functions and i would need some time to do that. so if u are still interested in solution let me know.

hyeee...

how can i capture the value of the last item not equal to 0 for each column in a cross-tab?

this is how the cross tab should look like:

Item Shop1 Shop2

Item Receive Issue Stock
Item0 0 0 40
Item1 0 10 30(Stock = Stock - Issue)
Item2 20 0 50(Stock = Stock + Receive)
Item3 0 0 50(takes the value of the last stock item)
...
GrandTotal 20(Sum of Receive) 10(Sum of Issue) 50(Value of the last stock item)

i really need help on how to display these data in a cross-tab..

the main problem is how to display the last item in Stock Grand Total Column when it is not a summary but an exact value instead.

Help needed, thanx!