Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
As i posted an image i want only those competency names which are not null