1 Reply Latest reply on May 3, 2017 4:22 PM by diego.medrano

    Export to Access (.mdb) - Wrong Column Order and Column Names

    Ross Moffitt
    Ross Moffitt Apr 28, 2017 8:06 AM

      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?

       

      Thanks!