# Insert data input rows Quite often, we would need to insert a row in our table/matrix reports in Power BI and enter our own data. For example, a financial statement report connecting to a database query may be able to fetch revenue & expense metrics, but it might not retrieve the number of shares outstanding. Similarly, a sales report can leave out the sales data for a newly launched product category. To address such scenarios, Premium Table allows you to insert static rows in where you can input or enter the data. ## 1. Insert data input row You can insert data input rows from the Insert tab > Insert Row menu. Please bear in mind that the Insert Row button will be disabled until you select a row in your report. Select the **Static Row** option from the Data Input menu.

Inserting static rows from the data input menu

Another way to insert static rows is by using the row gripper. The gripper icon is highlighted when you hover over a row. Click on it, then select the Insert > Add Static Row option.

Inserting static rows from the row gripper

#### 1.1. Data input row properties A side panel opens when creating a data input row. Type in the name of the category in the **Title** textbox and click Create. You will see an empty record created above the row that was selected.

#### **i. Scaling factor** You can set the scaling factor(Thousands, Millions, Billions, None, etc) for the static row depending on the data that is expected to be entered. It is set to Auto by default. #### **ii. Include in total** When the 'Include in total' option is enabled, any values we type in for the new row also contribute to the grand total row. #### 1.2. **Delete a static row** To delete a static row, hover over the row and click on the row gripper. Select the 'Delete Row' option. You can also delete rows from the **Manage Rows** interface that will be covered in subsequent sections.

--- # 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.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-rows.md?ask= ``` 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.