Dimension Tables

A dimension tables plays a critical role in data warehousing and has strong association with facts of the business process. It consists of descriptive attributes typically text fields which describe facts but are complete and have discreet values. Facts are the metrics that business houses use for making decisions. Dimensions are generally descriptions Read more

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

1 3 4 5 6 7 9