Flat Hierarchy empty columns filling

[Jay_Desilva]

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

[clmc9601]

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 · Accepted solution]

Find attached my solution.....

[Jay_Desilva · Accepted solution]

Thanks you!, It works