# Aggregating Subtable to Another Subtable

**URL:** <https://community.ragic.com/t/aggregating-subtable-to-another-subtable/15813>\
**Category:** Support\
**Created:** [July 10, 2024, 8:45am UTC](https://community.ragic.com/t/aggregating-subtable-to-another-subtable/15813 "2024-07-10T08:45:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![atsanon.wad](https://community.ragic.com/letter_avatar_proxy/v4/letter/a/ce7236/32.png) [@atsanon.wad](https://community.ragic.com/u/atsanon.wad)\
**Post date:** [July 10, 2024, 8:45am UTC](https://community.ragic.com/t/aggregating-subtable-to-another-subtable/15813/1 "2024-07-10T08:45:05Z")

</div>

Hi Ragicians!

I am using Ragic’s Accounting Lite template. Its Account Titles sheet has 4 grades, but I need 5 per the generally accepted practice around here. My idea to extend the functionality without disturbing too much hard-coded stuff (like the Balance Sheet or Income Statement) is as follows:

1. Create a table called Sub-Ledgers, with a Link field to Account Titles table.  

2. Create a subtable (A7) under the Journal Entries table, mimicking the Voucher Detail subtable (A13). The fields are a Link field to Sub-Ledgers (A7), a Load field from Sub-Ledgers (B7), a free text field, two number fields called Debit (F7) and Credit (G7), another Load field from Sub-Ledgers, which is the Link field in 1 (H7), and a Load field from Sub-Ledgers called Ledger Code (I7).  

3. Create a new sheet from the subtable A7, called Voucher Sub-Details.  

4. Aggregate Voucher Sub-Detail records by Ledger Code to Voucher Detail. If I add two entries in A7, then F7 should be aggregated to F13, and G7 should be aggregated to G13.  

I can’t finish the last step.

However, if anyone has a better idea, I’m all ears.

---

<div class="post-metadata">

**Author:** ![fabio](https://community.ragic.com/user_avatar/community.ragic.com/fabio/32/2909_2.png) [@fabio](https://community.ragic.com/u/fabio)\
**Post date:** [July 10, 2024, 9:57am UTC](https://community.ragic.com/t/aggregating-subtable-to-another-subtable/15813/2 "2024-07-10T09:57:01Z")

</div>

Hi,

For questions related to the accounting template, could you please submit a support ticket to allow our support staff to see if we can modify the settings on your template?