reporting hierarchy from the sample data attached.

[Ramesh Deo]

@Ramesh Deo
Hi!
Don't you think that even if Somendra Misra's solution doesn't fully fit your requirements, saying that the required format would be better than SM format does actually sound a bit rude?
Regards!

Sir,
Sorry for any mistake whatever i did? i just answered to narayan sir for his question to me about my requirement.

 

[Somendra Misra]

Hi Ramesh,

See the file here (Sheet2). Column D is formula, Columh H is dependent formula on Column D. ColumnK : ColumnR are macro result.

Just verify the results.

Regards,