> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Rows


## ${color}[#1a63ba](Rows)

#### ${color}[#1a63ba](Customize the header row)
"Hide header Row" ( ${color}[#f44823](**1**) ): No header row will be in the output file (Excel, CSV)

#### ${color}[#1a63ba](Add additional rows)
( ${color}[#f44823](**2:**) )
* after header row
* as first row
* as last row
* before each new item
* after each new item
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/row_443fjx.png)
If you use the position "before each new item" or "after each new item", you can access the values from other columns in the row, do calculations or apply advanced search and replace functions. 

| For more details, please refer to: [Set the Value of a Column](https://help.datachamp.io/en/article/set-the-value-of-a-column-gs7fmu/)

#### ${color}[#1a63ba](Use Excel formulas to calculate sum, average, ...)
This will work only for rows "as last row" ( ${color}[#f44823](**1**) ).
You can use any Excel formula to calculate values based on the column above, such as "SUM" or "AVERAGE". Just like in Excel, start your input with an "=" sign, for example: `=SUM`, `=AVERAGE`, or `=COUNT` ( ${color}[#f44823](**2**) ).

You can add as many "as last row" entries as you want, as shown in this example:
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/rows2_owvwxb.png)