2 Replies Latest reply: Apr 4, 2012 5:01 AM by Mano RSS

    Filterig a column

    Mano
      Hi All

      We have a requirement where we will have two different pivot tables in single report using one common column "Finance project code" , now this project code does contain some values starting with 02 , 05 , 09 etc. In one of our pivot tables , we need finance proect code starting from 09 alone and in other pivot table we need the same column to display values other than starting from 09.

      How can we achieve this , please reply me back on the same.

      This is quite urgent and your help is really appreciated.

      Regds
      Mano
        • 1. Re: Filterig a column
          MuRam
          Hi,

          1. Save As the report and create two separate pivot reports with the filter condition for the first report as
          IS LIKE (pattern match) '09%'
          and in the second report as
          IS not LIKE (pattern match) '09%'.
          And place the reports according to the desired view in the dashboard page.

          2. In the measure columns starting with 09 use
          FILTER("measure_column_name" USING ("Dimension_code_name" LIKE '09'))
          In the measure columns starting with 09 use
          FILTER("measure_column_name" USING ("Dimension_code_name" NOT LIKE '09'))

          Any of the ways which satisfies your requirement.

          Hope this helps.

          Regards,
          MuRam
          http://obiee10grevisited.blogspot.in/
          • 2. Re: Filterig a column
            Mano
            thanks a lot for your reply ram.