8 Replies Latest reply on Jul 25, 2013 3:28 PM by Laurent68

    Hiding columns in pivot table OBIEE 11g


      Hi experts,


      I am trying to create a pivot table with individual values in columns but I also need to display a grand total as values but also as percentage and as cumulative percentage.

      I duplicated the measure once in the measure area, and selected display data as percentage of column, and another time using display cumulative and percentage of column.


      The result is fine, but all the elements are displayed as column for the percentage and for the cumulative. Or, I only need the Grand Total Percentage and Cumulative, but I don't need all the columns for Percentage and cumulative.


      I have tried to find out a way to customize the XML but nothing good.


      Is there a way to display only the grand total for percentage and cumulative without having to display all the individual columns?


      Any help highly appreciated.