df and df2 are my dataframes when I join them, it flattens the index which I don't want
df =df.pivot_table(index=['LEVEL_3','tck'],values=['QTY'],columns=['A/B', 'YR'],aggfunc=np.sum) df2 = df.agg('sum',level =1, axis=1).add_prefix('Total ') df = df.join(df2, on=['LEVEL_3','tck']) df
It gives the result enter image description here But I want it like below, showing different levels- enter image description here
What can I do?