2 Replies Latest reply: May 7, 2012 2:57 PM by rcortez RSS

    Pivot Table "Show data as" Percent of Precision

    rcortez
      Hello,

      I'd like to know if there's a way to configure the Pivot Table "Show Data As - Percent of" precision.

      ATM, I have some reports using SR types where one of those are much bigger than the others.. So when the report its generated, it returns something like:

      TYPE A: 99%
      TYPE B: 0%
      TYPE C: 0%
      TYPE D: 0%

      How can I show the other types correct value? Something like number of decimal places...

      Ps: As criteria to this report, I have changed my Data Format to "Number", "Minus: -123" with 15 Decimal Places.

      Thanks,
      Ramon
        • 1. Re: Pivot Table "Show data as" Percent of Precision
          David_T
          902360 wrote:
          Hello,

          I'd like to know if there's a way to configure the Pivot Table "Show Data As - Percent of" precision.

          ATM, I have some reports using SR types where one of those are much bigger than the others.. So when the report its generated, it returns something like:

          TYPE A: 99%
          TYPE B: 0%
          TYPE C: 0%
          TYPE D: 0%

          How can I show the other types correct value? Something like number of decimal places...

          Ps: As criteria to this report, I have changed my Data Format to "Number", "Minus: -123" with 15 Decimal Places.

          Thanks,
          Ramon
          Yup. Can do. Read this link:

          http://shivabizint.wordpress.com/2008/09/14/changing-the-precession-of-percent-of-columns-in-pivot-table-of-obiee/
          • 2. Re: Pivot Table "Show data as" Percent of Precision
            rcortez
            Thanks David_T!!!