# ReportSheet Functions

## Content

ReportSheet provides formula functions for retrieving values from hierarchical spilled cells, performing contextual calculations, and getting pagination information.
The following ReportSheet-specific functions are available:

| **Category** | **Function** | **Description** |
| -------- | -------- | ----------- |
| @cols=1:@rows=5:Hierarchical Cell | [`R.V`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-value) | Returns values from a spilled cell based on the specified offsets or context cells. |
| [`R.A`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-value) | Specifies an absolute offset for retrieving a spilled cell value. This function is used as an argument of the `R.V` function. |
| [`R.R`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-value) | Specifies a relative offset for retrieving a spilled cell value. This function is used as an argument of the `R.V` function. |
| [`R.INDEX`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-index) | Returns the index of a spilled cell, optionally within the specified context. |
| [`R.RANK`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-rank) | Returns the rank of a spilled cell based on the specified context, sort order, and ranking mode. |
| @cols=1:@rows=4:Contextual Analysis | [`R.MOM`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/rmom) | Returns the month-over-month ratio of a cell value. |
| [`R.YOY`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/ryoy) | Returns the year-over-year ratio of a cell value. |
| [`R.PROPORTION`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/rproportion) | Returns the proportion of a cell value within the specified context. |
| [`R.CUMULATIVE`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/rcumulative) | Returns the cumulative value of a cell within the specified context. |
| @cols=1:@rows=2:Pagination | [`R.CURRENTPAGE`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/get-pagination-info) | Returns the current page number of the report or the current Master-Detail group. |
| [`R.PAGECOUNT`](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/get-pagination-info) | Returns the total number of pages in the report or the current Master-Detail group. The former name, `R.PAGESCOUNT`, is still supported for backward compatibility. |