Skip to Content

Crystal Report Crosstab:total on running total

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 22, 2017 at 08:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded