Skip to Content
0

Crystal Report Crosstab:total on running total

Aug 21, 2017 at 10:04 PM

49

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Aug 22, 2017 at 08:02 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you Abhilash very much!!!

0