We have a crosstab where we show a measure per day on the right side of the table.
However, when exported to excel, the dates are show as the first column. Users need to then do a pivot table.
It woudl be great to preserve the format when exporting to Excel.
Thank you for your suggestion. We are reviewing it, in hopes that it can be incorporated into a future release.
You should mention HOW you get the data to Excel. I an going to guess that you actually used Proc Export or an Export wizard. Export generates data in a form used for DATA interchange not reading report.
You can generate that appearance if you use ODS tagsets.Excelxp or ODS EXCEL with your table generator.
We are using a simple right-click and esporting data to excel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.