2 of 2 people found this helpful
Instead of Export..Go to Worksheet>Copy>CrossTab and then Paste in Excel.
Thank you Deepak,
The problem with that is for my users... some are willing to do "extra" clics or follow different paths to get their exports, but most of them I guess will avoid it.
I did find another post about this, but no solution.
What I ultimately did is to leave only one measure in my table (the rest I had to convert to dimension)...
This now allows us to export data respecting one line per row,,, not the best solution but in our case it works.
Greetings and thanks,