Exporting Filtered Data
* To export data from a visualization:
- Select File > Export > Data to File
- Click the Visualization radio button.
- Select the visualization to base the new data file on from the drop-down list.
Note: You can export all or marked data from a table, cross table or a summary table, or the marked data from any other visualization. You can also select to export the data currently shown in the Details on Demand.
- If both options are available for the selected visualization, select whether to export:
Data for all items - the rows remaining after the current filtering.
Data for marked items - the currently marked rows. Note that all marked rows will be exported, even if they are filtered out.
Note: The Data for all items option is only available if you have selected a table, a cross table, a summary table, or the Details on Demand in the Visualization drop-down list. Data for marked items is only available if there are marked items in the analysis.
- Click OK.
- Specify a file name and a location for the file in the Save As dialog.
- Click Save.
Note: You can export the data to a text file or to an Excel file.
* To export data from a data table:
- Select File > Export > Data to File
- Click the Data table radio button.
- In the drop-down list, select which data table to export data from.
- Select what data to export:
All rows - the entire data table regardless of all filtering.
Filtered rows - the rows remaining after the current filtering by the specified filtering scheme.
Marked rows - the rows marked in the visualizations using the specified marking. Note that all marked rows will be exported, even if they are filtered out. - Click OK.
- Specify a file name and a location for the data file in the Save As dialog.
- Click Save.
Note: You can export the data to a text file or to an Excel file.
Follow