This content has been marked as final. Show 2 replies
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