Hi all,
I am trying to put together an analysis that looks at balances month by month for a business unit/GL account combination. The example I've attached shows just one combination but there will be many. My current output is separating each period onto a different line but I would like it combined so I can take a look at one row of balances versus balances in multiple rows. And I would also be able to have a Period view if I wanted to see how many business unit/GL account combinations exist for a specific period.
Below shows my current output and what I would like to ideally get to.
Any help is appreciated! Thank you in advance!
