## PivotItem class

Represents a item in a PivotField report.



The PivotItem type exposes the following members:

### Properties
| Property | Description |
| :- | :- |
| [is_hidden](/cells/python-net/aspose.cells.pivot/pivotitem/is_hidden) | Gets and Sets whether the pivot item is hidden. |
| [position](/cells/python-net/aspose.cells.pivot/pivotitem/position) | Specifying the position index in all the PivotItems,not the PivotItems under the same parent node. |
| [position_in_same_parent_node](/cells/python-net/aspose.cells.pivot/pivotitem/position_in_same_parent_node) | Specifying the position index in the PivotItems under the same parent node. |
| [is_hide_detail](/cells/python-net/aspose.cells.pivot/pivotitem/is_hide_detail) | Gets and sets whether the pivot item hides detail. |
| [is_detail_hidden](/cells/python-net/aspose.cells.pivot/pivotitem/is_detail_hidden) | Gets and sets whether the detail of this pivot item is hidden. |
| [is_calculated_item](/cells/python-net/aspose.cells.pivot/pivotitem/is_calculated_item) | Indicates whether this pivot item is a calculated formula item. |
| [is_formula](/cells/python-net/aspose.cells.pivot/pivotitem/is_formula) | Indicates whether this pivot item is a calculated formula item. |
| [is_missing](/cells/python-net/aspose.cells.pivot/pivotitem/is_missing) | Indicates whether the item is removed from the data source. |
| [value](/cells/python-net/aspose.cells.pivot/pivotitem/value) | Gets the value of the pivot item |
| [name](/cells/python-net/aspose.cells.pivot/pivotitem/name) | Gets the name of the pivot item. |
| [index](/cells/python-net/aspose.cells.pivot/pivotitem/index) | Gets the index of the pivot item in cache field. |


### Methods
| Method | Description |
| :- | :- |
| [`move(self, count, is_same_parent)`](/cells/python-net/aspose.cells.pivot/pivotitem/move/#int-bool) | Moves the item up or down |
| [`get_formula(self)`](/cells/python-net/aspose.cells.pivot/pivotitem/get_formula/#) | Gets the formula of this calculated item.
<br/>Only works when this item is calculated item. |
| [`get_string_value(self)`](/cells/python-net/aspose.cells.pivot/pivotitem/get_string_value/#) | Gets the string value of the pivot item
<br/>If the value is null, it will return "" |
| [`get_double_value(self)`](/cells/python-net/aspose.cells.pivot/pivotitem/get_double_value/#) | Gets the double value of the pivot item
<br/>If the value is null or not number ,it will return 0 |
| [`get_date_time_value(self)`](/cells/python-net/aspose.cells.pivot/pivotitem/get_date_time_value/#) | Gets the date time value of the pivot item
<br/>If the value is null ,it will return DateTime.MinValue |



### See Also
* module [`aspose.cells.pivot`](..)