Count ALL in Section

I broke report in multiple sections. ex:

1A00

Account 001 $100.00
Account 001 $120.00
Account 003 $100.00
Account 930 $53.09

2A01

Account 001 $50.00
Account 043 $34.09
Account 930 $454.98

How can i add a column which will give me total sum based on Account number. Ex: I need total count of Account 001. Should be $270.00

1A00
                                 
Account 001     $100.00     $270.00
Account 001     $120.00     $270.00
Account 003     $100.00     $100.00
Account 930     $57.00       $500.00

2A01

Account 001      $50.00      $270.00
Account 043      $34.09      $34.09
Account 930      $443.00    $500.00

 

Answer: FOR EACH … IN REPORTS .

EX: =CountAll(<Account Name>) ForEach <Account Number> In Report

Leave a Reply