How to suppress the dimensions values for which measure is null

[veeranj]

HI,

I have two dimensions dim1  and dim2 in pivot table.

where dim2 are part of dim1 now i pivoted dim1

now my measure is avg(rating).

when i select any employee ,it should display only those dimension values what he know ,i want to suppress others which he dont know.

it should display only those where measure is not null.

i want to suppress those marked with red fields.

can anyone please help me

Thanks,

ANjee

[#2]

Not sure if I understand you correctly.

But you can try checking the option "Supress When Value is Null" in dimensions tab and "Supress Zero Values" or "Supress Missing" in presentation tab.

Hope this helps, if not please share your sample app.

[veeranj]

As i posted an image i want only those competency names which are not null