how do I get my report to show in this way....
Accounting Period - Account Number - Account Name - Subsidiary - Location - (and then the summary of all 10+amounts)
Currently it is showing all of the transactions and wont let me collapse based on location