how to show single time group name instead of multiple times

[SNR1]

Hi All,

i have two groups with hierarchy level

level 1 like owner of the group

level 2 is next manager 

level 3  is employee

when i show in the chart 

for level 2 and level 3 it shows like below

but i need in level 2 it shows once bill Simmons name and under it show reaming list

like same to fuyu also

i want to print only one time in level 2 names instead of multiple times

like below.

please suggest us  ASAP.

Thanks in Advance

[tresesco]

Use pivot table.

[SNR1]

HI Trecesco,

i used that option also no changes are reflected and the requirement is ti show in straight table only.

please help me

Thanks In Advance

[SNR1]

i need to show total on top of the expression and also i have 4 more calculated dimensions 

i'm getting same like that