how to hide /show the repeated values in straight table ASAP

[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.

in Straight table is user requirements

is there nay technique to hide repeated value ?

Please help me ASAP

 Thanks In Advance

[marcus_malinow]

In your chart properties, change the Dimension's text colour setting

If([Level 2]=Above(TOTAL [Level 2]), White())

[SNR1]

Hi Marcus,

it's showing error to me

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.

Thanks In Advance

[SNR1]

Hi All,

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

ASAP

Thanks Ina Adavance

[marcus_malinow]

Ok, so for this calculated dimension

again, text colour expression

if(if(AO_DimOVSRH=3,AO_DimOVAccountOwner)=Above(TOTAL if(AO_DimOVSRH=3,AO_DimOVAccountOwner)), White())

[SNR1]

HI Marcus ,

only two fields are removed next  one is still showing.

please help me Marcus

Thanks In Advance.

[marcus_malinow]

I'm guessing there are gaps in your data.

Suggest you post a sample data set / qvw

[SNR1]

my qvw around 150 MB n this is site is not taking that much amount.

let try   i will send you Marcus

is any other way to communicate with i will follow up with you .

 Give me 5 MIn

Thanks In Advance.

[SNR1]

Hi Marcus

is it possible to find the data gaps please help me 

i will send the app with in 5 min 

Thanks

[SNR1]

if possible please provide mail id i wiil fwd my app.

please find the data model