2 Replies Latest reply: Mar 19, 2014 3:25 AM by Veeranjaneyulu Pabbineedi RSS

    How to suppress the dimensions values for which measure is null

    Veeranjaneyulu Pabbineedi

      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.

      gh.JPG.jpg

      i want to suppress those marked with red fields.

      can anyone please help me

       

       

      Thanks,

      ANjee