When you export a crosstab from the TARGIT client to Excel, the export will use a default format.
You can change the export format by selecting the 'Custom export' option.
In Designer client's File menu:
Or in the right-click menu of an object:
In both cases, you can change these settings.
Notice the option to save the changes as a personal default setting.
Preferences in the Anywhere client
In the Anywhere client, changing the personal default settings can be done from the Preferences settings (the three dots) in the Anywhere client's upper right corner.
Examples of export formats
Preserve formatting and Do not repeat dimensions members:
Preserve formatting and Repeat dimension members:
Remove formatting and Repeat dimension members:
Comments
Please sign in to leave a comment.