| Table of Contents |
|---|
...
- Sort - ascending or descending
- Format - edit name and style, conditional formatting (see Formatting Data below)
- access Advanced Functions - browse through these if you need a more advanced calculation to see if one meets your requirements
- Group Data - display different related values as the same answer
- Add Filter - add chosen field as a filter
- Hide Field - from report if it is not needed to be visible but needed for a function
- Delete - from report if it is not needed to be visible or for a function
...
3.4 Formatting Data
- To change how data or columns are formatted, click on Format againstthe relevant column (outlined above) or click the following icon in the top menu.
- Click on the field/column you’d like to format. You can change a range of filter settings here:
- column title
- column format
- show or hide field
- suppress duplicates - leave this turned off unless you have a specific reason to turn on. Duplicate values are combined from the left most column first.
- sorting
- how data is displayed
- borders
- summary
