Hi dear Community
I Have a problem with a pivot table order dimentions. This is the structure for the dimentions
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