I'm starting to learn the formula's of Crystal Reports. I have version 8 and I can't figure out how to make a specific formula. I have a report grouped by region. Imagine there are 5 organisations in a region. Behind every organisation stands the sales amount of last year. I want to make an field behind that amount that shows the amount of that organisation added to the previous amounts in that group. Example:
organisation amount (this must be my formula)
organisation A $ 1500 $ 1500
organisation B $ 1000 $ 2500
organisation C $ 2000 $ 4500
Can you please help me by creating me this formula. I can't figure it out. Thank you,
Robbert van Spronsen.