Running total / Summary - 3 groups

24 Views

Dear All,

I am facing an problem in Summary / Running Total in my crystal Report. I have 3 groups as under :

1) Document Series

2) Territory

3) Transaction Details which includes Document Total

Now Example my document series is Projects and Territory is Japan and India and in Transaction Details which is document total has values of 100, 200, 300,500 for Japan and 300,400 for India

Now I am not able to bring a summary / running total of Japan which should be 1100 and for India 700 respectively.

I want summary for Document Series Also means for Projects it should show the total of 1100 + 700 = 1800

and a grand total of 1800 if its only projects series and if other series it should show projects + handling series.

Pleas help as I have tried but not been successful.

regards,

kamlesh