1 Reply Latest reply on Jan 7, 2016 10:26 AM by jprakash

    Hiding of rows in pivot table view

    3024008

      Hi,

       

      I want to hide the rows in a pivot table view based on a conditon. for ex:

       

      i have a pivot view with following structure

       

       

       

       

      Op CodeVoyageop costrunning costtotal
      v1010011001101
      20000
      30100100200

       

      Now i need to hide the row which has total 0.. the measure are coming from same column but not calculated in OBIEE.

       

      Regards

      Sreekanth

        • 1. Re: Hiding of rows in pivot table view
          jprakash

          Sreekanth,

           

          You can achieve using selection step.

           

          • Right-click a row at left most column (Op Code in ur case)
          • From the context menu choose the column name( Op Code) -> Remove -> Based on Custom Codition. In my case the column name is "Per Name Month"

          selstep.png

           

          • Choose the condition for total "0"

          cond.png

           

          Thats it. You are done!

           

          Thanks, JP