SOLVED
Flat Hierarchy empty columns filling
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Jay_Desilva
5 - Atom
‎12-06-2021
10:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a flat Hierarchy data source and need to fill-up the Null levels with values. Please help. Thank you in advance
Source file
Desire output
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3
13 - Pulsar
‎12-06-2021
10:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Jay_Desilva,
Here's an example solution. If you have more than five levels, it would probably be better to transpose them and apply Multi-Row formula logic instead.
If this helps, please consider marking it as a solution so others may find it.
binay2448
11 - Bolide
‎12-06-2021
11:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-07-2021
06:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks you!, It works
