8 Replies Latest reply: Jul 25, 2013 10:28 AM by Laurent68 RSS

    Hiding columns in pivot table OBIEE 11g

    Laurent68

      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.

       

      Regards