Sum valuesintegration account values

[FilipaPereira]

Hello, 

I'm having trouble adding up the totals in a chart of accounts.
In the chart of accounts, I have integration accounts (DR), intermediate accounts (GA) and transaction accounts (GM), the transaction accounts are the only ones that have a value, but I needed the integration and intermediate accounts to be totalizers of the transaction accounts, how can I do this calculation?

Can you help?

[hnguy71 · Accepted solution]

Hi @FilipaPereira 

Seems you have relevant information to build a ragged parent-child hiearchy. Essentially you'll need to build your table into this structure instead:

Follow Imke's guide on how to transform your table and you should be good to go:

https://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-po...

[FilipaPereira]

Hi @hnguy71 

This is the CoA, I tried to aggregate by level, but I still couldn't do it.

AccountID	GroupingCategory	GroupingCode	Valor
12	GR
12001	GM	12	100
12002	GM	12	200
12003	GM	12	300
12004	GM	12	400
12005	GM	12	500
12006	GM	12	600
12007	GM	12	700
12008	GM	12	800
12010	GM	12	900
12011	GM	12	1000
12012	GM	12	1100
13	GR
131	GA	13
131003	GM	131	100
21	GR
211	GA	21
2111	GA	211
21111	GA	2111
211110002	GM	21111	100
211110011	GM	21111	200
211110041	GM	21111	300
211110055	GM	21111	400
211110070	GM	21111	500
211110071	GM	21111	600
211110075	GM	21111	700
211110076	GM	21111	800
211110078	GM	21111	900
211110080	GM	21111	1000
211110081	GM	21111	1100
211110082	GM	21111	1200
2114	GA	211
21141	GA	2114
211410001	GM	21141	100
211410056	GM	21141	200
211410304	GM	21141	300
211410305	GM	21141	400
218	GA	21
2181	GA	218
21811	GA	2181
218110011	GM	21811	100
218110055	GM	21811	200
22	GR
221	GA	22
2211	GA	221
22111	GA	2211
221110006	GM	22111	100
221110007	GM	22111	200
221110010	GM	22111	300
221110011	GM	22111	400
22112	GA	2211
221120169	GM	22112	100
221120273	GM	22112	200
221120447	GM	22112	300
221120512	GM	22112	400
221120595	GM	22112	500
221120656	GM	22112	600
221120682	GM	22112	700
221120746	GM	22112	800
22113	GA	2211
221130725	GM	22113	100
2214	GA	221
22141	GA	2214
221410001	GM	22141	100
221410003	GM	22141	200
225	GA	22
2251	GA	225
22511	GA	2251
225110053	GM	22511	100
225110069	GM	22511	200
225110071	GM	22511	300
225110171	GM	22511	400
225110342	GM	22511	500
225110461	GM	22511	600
225110467	GM	22511	700
225110563	GM	22511	800
225110695	GM	22511	900
225110712	GM	22511	1000
22512	GA	2251
225120447	GM	22512	100
2254	GA	225
22541	GA	2254
225410003	GM	22541	100
23	GR
231	GA	23
2311	GM	231	100
2312	GM	231	200
232	GA	23
2322	GM	232	100
238	GA	23
2382	GA	238
238201	GM	2382	100
24	GR
241	GA	24
2411	GA	241
24111	GM	2411	100
2412	GA	241
24121	GM	2412	100
24122	GM	2412	200
2413	GA	241
24131	GM	2413	100
24132	GM	2413	200
24133	GM	2413	300
2415	GM	241	400
2416	GM	241	500
242	GA	24
2421	GA	242
24211	GM	2421	100
2422	GA	242
24221	GM	2422	100
2423	GA	242
24232	GA	2423
242322	GA	24232
2423221	GM	242322	100
2424	GA	242
24241	GA	2424
242411	GM	24241	100
24242	GA	2424
242421	GM	24242	100
243	GA	24
2432	GA	243
24321	GA	2432
243211	GA	24321
2432111	GA	243211
243211106	GA	2432111
2432111061	GA	243211106
24321110611	GM	2432111061	100
2432112	GA	243211
243211213	GA	2432112
2432112131	GA	243211213
24321121311	GM	2432112131	100
2432113	GA	243211
243211323	GA	2432113
2432113231	GA	243211323
24321132311	GM	2432113231	100
2432113232	GA	243211323
24321132321	GM	2432113232	100
24322	GA	2432
243221	GA	24322
2432211	GA	243221
243221106	GA	2432211
2432211061	GA	243221106
24322110611	GM	2432211061	100
2432211062	GA	243221106
24322110621	GM	2432211062	100
24322110671	GM	2432211061	200
2432212	GA	243221
243221213	GA	2432212
2432212131	GA	243221213
24322121311	GM	2432212131	100
2432212132	GA	243221213
24322121321	GM	2432212132	100
24322121371	GM	2432212132	200
2432213	GA	243221
243221323	GA	2432213
2432213231	GA	243221323
24322132311	GM	2432213231	100
2432213237	GA	243221323
24322132371	GM	2432213237	100
24323	GA	2432
243231	GA	24323
2432311	GA	243231
243231106	GA	2432311
2432311061	GA	243231106
24323110611	GM	2432311061	100
2432312	GA	243231
243231213	GA	2432312
2432312131	GA	243231213
24323121311	GM	2432312131	100
2432312132	GA	243231213
24323121321	GM	2432312132	100
2432312139	GA	243231213
24323121391	GM	2432312139	100
2432313	GA	243231
243231323	GA	2432313
2432313231	GA	243231323
24323132311	GM	2432313231	100
2432313232	GA	243231323
24323132321	GM	2432313232	100
2432313237	GA	243231323
24323132371	GM	2432313237	100
2432313239	GA	243231323
24323132391	GM	2432313239	100
243231390	GA	2432313
2432313901	GA	243231390
24323139011	GM	2432313901	100
2433	GA	243
24331	GA	2433
243311	GA	24331
2433111	GA	243311
24331111	GA	2433111
2433111106	GA	24331111
24331111061	GM	2433111106	100
24331113	GA	2433111
2433111323	GA	24331113
24331113231	GM	2433111323	100
243312	GA	24331
2433121	GA	243312
24331211	GA	2433121
2433121106	GA	24331211
24331211061	GM	2433121106	100
24331212	GA	2433121
2433121213	GA	24331212
24331212131	GM	2433121213	100
24331213	GA	2433121
2433121323	GA	24331213
24331213231	GM	2433121323	100
243313	GA	24331
2433131	GA	243313
24331311	GA	2433131
2433131106	GA	24331311
24331311061	GM	2433131106	100
24331312	GA	2433131
2433131213	GA	24331312
24331312131	GM	2433131213	100
24331313	GA	2433131
2433131323	GA	24331313
24331313231	GM	2433131323	100
243314	GA	24331
2433141	GA	243314
24331411	GA	2433141
2433141106	GA	24331411
24331411061	GM	2433141	100
24331412	GA	2433141
2433141213	GA	24331412
24331412131	GM	2433141213	100
24331413	GA	2433141
2433141323	GA	24331413
24331413231	GM	2433141323	100
24336	GA	2433
243361	GA	24336
2433611	GA	243361
24336113	GA	2433611
2433611323	GM	24336113	100
243362	GA	24336
2433621	GA	243362
24336211	GA	2433621
2433621106	GM	24336211	100
24336212	GA	2433621
2433621213	GM	24336212	100
243363	GA	24336
2433631	GA	243363
24336312	GA	2433631
2433631213	GM	24336312	100
24336313	GA	2433631
2433631323	GM	24336313	100
24337	GA	2433
243372	GA	24337
2433721	GA	243372
2433721106	GM	2433721	100
24337212	GA	2433721
2433721213	GM	24337212	100
24337213	GA	2433721
2433721323	GM	24337213	100

[hnguy71]

Hi @FilipaPereira 

As long as you have the proper Chart of Accounts (CoA) hierarchy, you should be able to aggregate and get the sum at each level. Also, you may want to use a matrix visual instead.

Can you share a sample of your CoA table?