This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to format a trial balance that isn't structured correctly. I attached a file showing the inputs and the desired output. I also added screenshots of the file incase that was also helpful. I would like the IFRS codes to be subtotals of all the accounts rolling up into it. Please note that if any account have zero balances I still want them to be included and if a IFRS code doesn't have any associated accounts I still want it to be included too, just like in the example output. I'm usually pretty good with alteryx but for some reason I can't figure this one out. Please help! Thanks!!!!