Duplicate Row Data by Category and Period
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Output
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CEglinton
Just give a try. 😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much @Qiu and @ahsanaali !! The solution by @Qiu worked!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CEglinton
Thank you for the feedback and glad it helps.
