I did the following like the help file says: But still am having issues.
To add subtotals to a summary:
Double-click on the key field to display the Key Field dialog.
Click the Display tab at the top of the dialog.
Under the After Each Key Value Change heading, select the Insert Subtotal Line check box.
Displaying Blank Lines Along with Subtotals
When the Insert n Blank Line(s) After Each Key Value Change option is also selected, Monarch inserts the subtotal line first, then the blank line.
Add a subtotal label in the Label field (optional). You can add an identifying label to the subtotal line by entering the label text in the Label box. For example, to add a subtotal label for the Customer key field, you might enter "Customer Total". You can also choose to have the key value displayed to the right or left of it by selecting the Include Key Value in Subtotal Label On check box and selecting Right or Left.
Monarch re-displays the summary including subtotal lines.
When i perform the process it does not perform the break after each distinct symbol rather after each symbol, i need that fixed, this is my problem. If you noticed the colum where ICAD and below is the symbol, and these symbols are not being grouped up and the subtotal is below the change in symbol.
I will try to play around on my end but have had problems with the subtotal function, please let me know if you have any advice to fix this.
2009-10-22 C Resolved ICAD 2009-10-19 5775 3000
2009-10-22 C Resolved Subtotal 5775 3000
2009-10-22 S Resolved LQD 2009-10-19 -52185 -500
2009-10-22 S Resolved Subtotal -52185 -500
2009-10-22 S Resolved LQD 2009-10-19 -260948 -2500
2009-10-22 S Resolved Subtotal -260948 -2500
2009-10-22 S Resolved LQD 2009-10-19 -104380 -1000
2009-10-22 S Resolved Subtotal -104380 -1000
2009-10-22 S Resolved LQD 2009-10-19 -29229.2 -280
2009-10-22 S Resolved Subtotal -29229.2 -280
2009-10-22 S Resolved LQD 2009-10-19 -143547.53 -1375
2009-10-22 S Resolved Subtotal -143547.53 -1375
2009-10-22 S Resolved LQD 2009-10-19 -112752 -1080
2009-10-22 S Resolved Subtotal -112752 -1080
2009-10-22 S Resolved LQD 2009-10-19 -150346.51 -1440
2009-10-22 S Resolved Subtotal -150346.51 -1440