Reported: January 31, 2017.
Version(s) affected: DataSight 3.0 and 3.1.
Issue: Microsoft SQL views of pivoted datasheets are not saved in pivoted tables. Linking the views to other software products such as Microsoft Excel, then does not produce the desired pivoted tabulation.
Workaround: Save the pivoted datasheets inside DataSight. Then, set up tasks to export .csv, .xls or .xlsx files out to locations on the device or network. The exported files will present your data in pivoted tables.
Unfortunately, we are unable to advise a workaround for this issue with other software products. Please consider upgrading to the next available release with a fix.
Resolution: Fixed in DataSight 3.2.
Last Updated: June 23, 2017.