Latest value and running total in same report

[lesp1]

Can anyone advise me if there is a way to define a report that will show e.g. current months figures and a total for the year in the same report.
Data is along lines of:
Month
StockCode
VolumeOrdered
VolumeSold

Report would look something like:

StockCode Month VolumeSoldinMonth VolumeSoldinYear
OP8 June 02 10 35

etc..

where VolumeSoldinYear would be sum of VolumeSold where month <= current month.

Any help would be greatly appreciated

Les

 

[IdoMillet]

Just create two Running Totals with a different condition in each.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com