Summing running totals by group

[tsjd]

I have a table e.g like this

Fiscal Period Name Total
------------- ------ -------
01 xx 5
01 xx 5
02 xx 4
02 xx 3
03 xx 2

How do I create a running total for each one of the periods at the end of each group? So it would appear something like this

Fiscal Period Name Total
------------- ------ -------
01 xx 5
01 xx 5
---
10
---
02 xx 4
02 xx 3
---
7
---
03 xx 2
---
2
---

 

[lbass]

Insert a group on period and then right click on the total field and insert a summary at the group level.

-LB

 

[tsjd]

mind to elaborate there. Not quite sure of the solution there. I'm using crystal 8.5

 

[tsjd]

I tried using the sum there but the values do not seem to be adding up. Also tried evaluating where on the change of the period field but still doesn't add up properly.

 

[tsjd]

solved It was my evaluation and reset arguements which were incorrect Thanks

 

[lbass]

If your detail records look as you show above, there is no need to use running totals. You can just insert summaries. Running totals are slower.

-LB