# Calculated Column

## Description:

### Allowed Parent Components:

1. PivotGrid

### Allowed Child Components:

1. Popover
2. Pulse
3. Trigger Before Render

### Properties

### ➤ Title

Allowed Values: StringNumberExpression

### ➤ Width

Allowed Values: Any number value

### ➤ View Attribute

Allowed Values: Attribute

### ➤ Alignment

Allowed Values:

1. Default
2. Start
3. Center
4. End

### ➤ Resizable

Check this property to allow a user to resize the columns. Columns can be resized by dragging the edge of the column header to the right or left.

Allowed Values: Yes/No

### ➤ Sortable

Check this property to enable the sorting of data in ascending or descending order on click of column header

Allowed Values: Yes/No

### ➤ Header Tool Tip

A message which appears when a cursor is positioned over.Note: Use '$title$' to get the column title Ex:$title$

Allowed Values: An expression which should return string after evaluation

### ➤ Tool Tip

A message which appears when a cursor is positioned over.Note: Use '$title$' to get the column title and $viewAttribute$ to get the viewAttribute of the column as it is generated dynamically. Ex:#{dsAlias.$viewAttribute$}

Allowed Values: An expression which should return string after evaluation

### ➤ Tool Tip Position

Select an option to change the placement of the tooltip when appears.

Allowed Values:

1. left
2. right
3. top
4. bottom

### ➤ Show Negative In Brackets

Check this property to show the negative value separately in braces

Allowed Values: Yes/No

### ➤ Hide Repeated Values

Enable this property to hide duplicate values from being displayed on the pivot grid.

Allowed Values: Yes/No

### ➤ Format

Allowed Values: Free text field

### ➤ Pretty Date

Allowed Values: Yes/No

### ➤ Expression

Expression

Allowed Values: Expression

### ➤ Type

Choose the data type of the expression result. On the basis of the selected data type, the HTML input field will be displayed as pivot column.

Allowed Values:

1. date
2. number
3. string


---

# 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.cloudio.io/ui-components/widgets/iopivotgridcalculatedcolumn.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.