I have a customizable straight table that the users create by choosing dimensions and measures.They then drag and drop the columns to the order they prefer and then bookmark specific reports.
I am using dynamic expressions to hide show the columns. There are over 700 measures so this has to be done. When they drag the order for the columns it then shifts the order of the column into a random order. Is there a way to set columns back into the correct order with a macro?