Hide one of the bars

[#1]

Attached is the picture of my graph where i want to hide '-' and 'did not use' Bars so the total number will add up to 100 for satisfaction

VERY VERY IMPORTANT

[brindlogcool]

You can hide this '-' column by  enabling the option  Supress when the value is null.Refer the attached image.

Either you using calculated dimension or your column has a null value.

[MayilVahanan]

HI

In Dimension tab

tick -> Suppress When Value is Null

Expression

=Sum({<FieldName -= {'*did not*'}>}Count)/Sum({<FieldName -= {'*did not*'}>}total Count)

Hope it helps