0 Replies Latest reply: Apr 7, 2012 5:37 PM by Marcos Herrera RSS

    Pivot Table Order

      Hi dear Community

       

      I Have a problem with a pivot table order dimentions. This is the structure for the dimentions

       

      Great Group

         Group

            SubGroup

              Indicator

       

      And i have a colum order per each clasification (Order Column Great Group, Order Column Group, Order Column, SubGroup and Order Column Indicator).

       

      The problem are with som group or subgrup are null or ' '. in the structure some indicadors doesn´t have group or subgroup.

       

      This is the Result

       

      Problem Pivot Table.png

       

      And this is the desired result

       

       

      Desired Pivot Table.png