
# Pivot Distinct

You can display the types of values displayed in the pivot as unique values.

<GridView demo='pivotguides/08-pivotDistinct/01' height={600}/>

#### Set unique values

To set the display of unique values, set [Value Type](http://help.realgrid.com/pivotApi/types/ValueType/) of the setPivotFields function to "distinct".

```
pivot.setPivotFields({
     columns: ["Major Category", "Medium Category"],
     rows: ["Material classification", "Description", "Classification"],
     values: [{
         name: "Baseline value",
         expression: "sum"
     }, {
         name: "N/A",
         expression: "distinct"
     }]
});
```

#### Unique data

Displays data and images in the form of HTML tags in cells.
Unique data is displayed in a cell only when all identical items have the same data.

```
// display image
{
     "fieldName": "<img src='images/uncheck.png'>"
     ...
}

// display string
{
     "fieldName": "<font color='blue'>▼</font>"
     ...
}
```