1 of 1 people found this helpful
To download the data with the formatting of the crosstab, does selecting the download icon and selecting 'Crosstab' instead of 'Data' work as desired?
That actually works.. Thank you.
But can someone explain to me why isnt the data option (underlying and summary) not producing the data in sorted order as it appears in workbook ?
It looks like the underlying maintains the same order as the original data source.
I'm not sure where the order is coming from in the Summary tab, it doesn't look to be either the order in the view or the data source order. I will let you know if I'm able to find out more about where it is coming from.
Okay , thank you. That will be very helpful