Group row, error in hierchy.

[Forum User_ 7842]

When group level 2s in level 1 thing in video happens -(When last row of level 1 is included in a level 2 hierchy. Grouped data should be in level 2 but its beyond level 3 as in the video in attachment)
When all level 2 headers are selected and grouped for level 1 thing in image happens-

 

[Forum User_ 7842]

Image - https://www.excelforum.com/attachme...-group-row-errorin-hierchy-pls-help-excel.png
Video - https://www.excelforum.com/attachme...ow-errorin-hierchy-pls-help-excel-gruping.zip