Link to home
Start Free TrialLog in
Avatar of Jerry Seinfield
Jerry SeinfieldFlag for United States of America

asked on

cross tab report accumulative amount

Please help:

How can I insert an accumulative amount of values that they are in a cross tab report .
i.e.
              YYY
valueA  100
XXY        99
ValueB 200
YYY        99
ACC    300 (valueA+value B)
valueC 100
ZZY      99
ACC2 400 (valueA+value B+valueC)

how calculate ACC and ACC2?
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Recent versions of Crystal support "Calculated Members".
See a video demo at: https://www.youtube.com/watch?v=RpAEJqFe4IY
Avatar of Mike McCracken
Mike McCracken

If that doesn't work, what are the values?  
Are they fields from the database?
Are they formulas?

If they are formulas what are the formulas?

mlmcc
Avatar of Jerry Seinfield

ASKER

When I add a calculated member it create a column.
But I'm looking for a row, the ACC should be in the row.
I'm trying with an Embedded summary, but it's repeting same result in all columns. it doesn't work also.

Some are formulas, some come from database, depends on the group
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Solution Guys,
I used this function to  a couple of embedded summaries
GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 )+ GridValueAt (CurrentRowIndex, CurrentColumnIndex ,3 )
It works well.
Thanks for help