Editing a Summary in Data Prep Studio

You can edit a summary to change its name, select a different filter to apply when building the summary, add or remove key fields, measures or item fields, or edit the properties of key, summary, or item fields

Steps:

1. Click the Analyze tab to display the Summary options

2. Select the summary to edit from the Summary drop-down.

3. Click the Edit Summary button.

   

    

   The Edit Summary dialog displays. This dialog will show all of the details you specified when you created the original summary. Using this dialog, you can:

   • Select new/remove rows

   • Select new/remove columns

   • Select new/remove measures

   • Modify the field names of individual columns

   • Suppress duplicate field values

   • Change the order of the fields

   • Insert blank lines to the summary

   • Insert total lines to the summary

   • Modify the calculation assigned to a given measure

   • Drill up or down a summary

   • Specify matching key values

   • Sort fields

   • Apply a filter to the summary