My excel file contains balance sheet &P/L a/c tab. In balance sheet it has data of different subsidiaries of organisation(say 10 subsidiaries). Now i want to show along with the present data "Current asset","all assets", "current liabilities", "all liabilities" total of all subsidiaries.For example:- i want a total B2 to B12 Cell in B13 , total of c2 to c12 in c13 then i want Total of B15 to B25 in B26, total of c15 to c25 in c26 and so on for other cells also In excel, i would have added a row(13th or 26th row in my example) in between and would be simply doing sum. How to do in alteryx?
In the attached file, cells marked in yellow in output is what i need.Any help in this respect will be highly appreciated.
