Duplicate Row Data by Category and Period

[CEglinton]

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!

[Qiu · Accepted solution]

@CEglinton 
Just give a try. 😁

[ahsanaali]

@CEglintonhope this works as well, although I personally like the solution provided by @Qiu :)

[CEglinton]

Thank you so much @Qiu and @ahsanaali !! The solution by @Qiu worked!

[Qiu]

@CEglinton 
Thank you for the feedback and glad it helps.