how to show single time group name instead of multiple times in straight table

[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

[KishorePandurangan]

Best way of presenting this is in PIVOT Table, that has the way of presenting the data in a table as your expected output.

[SNR1]

HI Kishore ,

but here issue is only with level 2 only reaming fields and all other tables coming properly for this.

i'm using below ex pr as a dimension
=if(SO_SRH=3, SO_Group)

please suggest me.

Thanks in Advance.

[KishorePandurangan]

can you attach the sample qvw

[SNR1]

my file more than 200mb

i just sending silimer type file

Thanks

[SNR1]

HI All,

i'm using for level 2(is a label) as calculated dimension

level 2 is label name

Dimension is ==(if(AO_DimOVSRH=3,AO_DimOVAccountOwner))

please suggest how to proceed.

slimler way level 1 also i need to follow.

Please suggest me its urgent to me.

[SNR1]

Hi All,

Could you please suggest how to hide the repeated value fro conditional Dimension s in straight table

ASAP

Thanks Ina Advance