When grouping rows, I have 3 levels of data and 2 grouping sets. As I expand the first level grouping the data aligns correctly under the appropriate column headers that it belongs to. However, when I expand the 2nd level grouping my 3rd level data aligns far left and not back under the relevant column headers. The data is misaligned after 2nd tier expansion. Is there a way I can adjust/correct the alignment to be back under the appropriate column header, exactly like the expansion after 1st tier grouping.
Tried parent/child tables and other custom adjustments Expecting the data to align properly under correct columns