1 Reply Latest reply on Mar 30, 2015 9:53 AM by asim cholas

    Issue with Grand Total in Pivot Table Percentage

    2845107

      Hi

       

      Recently we have migrated from 11.1.1.7.131017 to 11.1.1.7.150120 version.


      In version 11.1.1.7.150120 there is one report which has pivot view in it. For that report for null values Grand Total is showing 100.0%.. The required result is it should display same null value.

       

      For the measure column 'Percent off'/'row' is selected for 'Show data as'.

       

      This issue is only coming when we have above 'Percent off'

       

      When we have 'Show data as' 'values' zero is coming up in Grand total which is expected.

       

      Please suggest if any workarounds are there for this issue.

       

      Thanks.