1 Reply Latest reply: May 29, 2012 1:05 PM by David_T RSS

    Report Design Help

    GRK
      I have, the following report - Obiee 10g, Answers Section

      Employee Age Range No. Of Employees Highly Exp. Employees % Highly Exp. Employees

      <20 100 50 50%
      20-50 50 10 20%
      50+ 50 5 10%


      But, I want the report in this format :

      Employee Age Range No. of Employees Number/percent Exp.Employees
      <20 100 Number 50
      <20 100 Percent 50%

      20-50 50 Number 10
      20-50 50 Percent 20%


      50+ 50 Number 5
      50+ 50 Percent 10%


      Please, guide me how to acheive this.

      Edited by: 831909 on May 29, 2012 7:41 AM

      Edited by: 831909 on May 29, 2012 7:47 AM
        • 1. Re: Report Design Help
          David_T
          831909 wrote:
          I have, the following report - Obiee 10g, Answers Section

          Employee Age Range No. Of Employees Highly Exp. Employees % Highly Exp. Employees

          <20 100 50 50%
          20-50 50 10 20%
          50+ 50 5 10%


          But, I want the report in this format :

          Employee Age Range No. of Employees Number/percent Exp.Employees
          <20 100 Number 50
          <20 100 Percent 50%

          20-50 50 Number 10
          20-50 50 Percent 20%


          50+ 50 Number 5
          50+ 50 Percent 10%


          Please, guide me how to acheive this.
          In your pivot table, duplicate the measure "Exp. Employees" and change the "Show Data As" to "percent of" and choose your value.