I have about 20 blue pills on the row shelf (combination of dimensions and measures) as discrete dimensions inside a grid and 1 aggregated Summed measure also on the row shelf.
Then I go to: Worksheet>Export>Data and Select to create a .mdb
1) The columns are not in the same order as on my grid. They are in alphabetical order. How can I get them in the same order as on my grid?
2) The aggregated measure has the word "SUM" in the column title. How do I remove that?
Looks like you're going to want the workaround solution provided here: