2 Replies Latest reply on Jun 17, 2013 10:14 AM by User521140-OC

    Hide rows in Pivot table Calculated Items in OBIEE 11g

    User521140-OC

      Hi All,

       

      I have requirement to show values in Pivot table such that values are divided into two sub totals and also shown in Grand Total.

       

      For Sub Total 1, all the rows can be shown with Sub total value. But for Sub Total 2, only Total value is to be shown but not all the rows. How this requirement can be done?

       

      I tried to hide the rows in Sub total 2, but its effecting entire table so those rows are removing from Sub total 1 aswell which should not happen.

       

      Have look in below table for more clarity. My output should be as shown in Table 2 not as in Table 1.

       

      Table 1:

      Q1Q2Q3Q4
      GeographyType
      AsiaT1100200300400
      AmericaT2110210310410
      EuropeT1120220320420
      SubTotal1 3306309301230
      AsiaT110203040
      AmericaT215253545
      EuropeT120304050
      SubTotal2 4575105135
      Grand Total 37570510351365

       

       

      Table 2:

      Q1Q2Q3Q4
      GeographyType
      AsiaT1100200300400
      AmericaT2110210310410
      EuropeT1120220320420
      SubTotal1 3306309301230
      SubTotal2 4575105135
      Grand Total 37570510351365

       

      Any ideas how this can be done??

       

      Thanks for your time.