Pivot Table Order

[#1]

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

And this is the desired result