Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
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:
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:
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 |
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
119 | |
83 | |
47 | |
42 | |
33 |
User | Count |
---|---|
190 | |
78 | |
72 | |
54 | |
45 |