Crystal Report Crosstab:total on running total

[Former Member]

Hello,

I would appreciate any advice on how to find crosstab column total for two running total rows.

………………………………………………………..Jul-17………………..Aug-17

Running Total –field 1…………………………..23…………………………45

Running Total—field 2…………………….…..34…………………………17

TOTAL………………………………………………….???..........................???

Thanks a lot.

[abhilash_kumar · Accepted solution]

Hi Alisia,

Right-click the second summary field > Select "Embedded Summary" > Select "Insert Embedded Summary".

A new cell with the text "Edit this formula" is added. Right-click this cell > Select "Embedded Summary" > Select "Edit Calculation Formula" and use this code:

GridValueAt(CurrentRowIndex, CurrentColumnIndex, 0) + GridValueAt(CurrentRowIndex, CurrentColumnIndex, 1)

-Abhilash

[Former Member · Accepted solution]

Thank you Abhilash very much!!!