# View and edit field properties

While most users can view the properties of a field in Analyzer, select users can edit a few of these properties, depending on the type of the field, such as level, time period, or measure. To edit these properties, you must be assigned the **Manage Data Sources** operation permission in Users and Roles. For more information on setting and maintaining permissions and roles for users, see [Use Pentaho Security](/pba/9.3-analytics/pentaho-user-console/about-pentaho-user-console-perspectives/administration/manage-users-and-roles-in-puc.md).

1. In the **Available Fields** list, right-click the field name you want to view or edit.
2. From the menu that displays, click **Properties**.

   The Properties dialog box displays for the field.
3. View or edit the following information about the field:

| Field property                      | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| ----------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Display Name**                    | <p>The name of the field as it appears in the <strong>Available Fields</strong> list. If you <a href="/pages/SYIHDUAf10p4Ij8KM4h8">renamed this field</a> in the <strong>Layout</strong> panel or the report pane, a notification with the new name will display below.</p><p>If you are assigned the <strong>Manage Data Sources</strong> permission, you can edit the name of this field. The edited name will display in the <strong>Available Fields</strong> list, as well as in the <strong>Layout</strong> panel and the <strong>Report</strong> pane unless you have renamed the field. <a href="/pages/SYIHDUAf10p4Ij8KM4h8">Renaming a field</a> within the <strong>Layout</strong> panel or the report pane will not affect the display name of the field in the <strong>Available Fields</strong> list.</p> |
| **Aggregation** (for measures only) | <p>The aggregation type is how the measure combines the data. Use the drop-down list to select an aggregation type from a system-defined list. Options include:- <strong>SUM</strong></p><ul><li><strong>AVERAGE</strong></li><li><strong>COUNT</strong></li><li><strong>COUNT\_DISTINCT</strong></li><li><strong>MINIMUM</strong></li><li><strong>MAXIMUM</strong><br>Note that <strong>COUNT</strong> and <strong>COUNT-DISTINCT</strong> are only applicable for non-numeric fields.</li></ul>                                                                                                                                                                                                                                                                                                                       |
| **Format**                          | <p>Choose how this level or measure should be formatted, such as currency, general number, percentage, or date. Use the drop-down arrow to select a format from a system-defined list, or type in the field to enter a custom format. Note that the <strong>Format</strong> field only displays when the value for the field is a number or a date.</p><p>See <a href="/pages/qHdK5q5Z1WNkaQ4cUB05">Format Field Options</a> for more information on selecting the appropriate format for your report.</p>                                                                                                                                                                                                                                                                                                              |
| **Description**                     | The description of the field, if any. This field is always read-only.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| **Type**                            | The type of field, such as level, time, or measure. This field is always read-only.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| **MDX**                             | The formula for the level or field as an MDX statement. This field is always read-only.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| **Member Properties**               | If a field has a number in parenthesis next to it in the **Available Fields** list, such as `Customer(6)`, then the dimension has member properties associated with it. When you open the Properties dialog box, you will also see a list of the member properties in addition to other details about the field. This field is always read-only.                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pba/9.3-analytics/pentaho-analyzer-cp/working-with-analyzer-fields/viewing-and-editing-field-properties/view-and-edit-field-properties.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
