--- title: "Refer to Block settings" slug: "refer-to-block-settings" description: "Utilize the \"Refer to\" function in Block settings to customize Data Block aggregation by Entity members, enhancing data display precision." tags: ["Developer", "Layout Editor", "Planner"] updated: 2026-08-05T12:24:07Z published: 2026-08-05T12:24:07Z canonical: "help.board.com/refer-to-block-settings" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.board.com/llms.txt > Use this file to discover all available pages before exploring further. # Refer to Block settings The "Refer to" option available in Block allow users to aggregate a Data Block with more detail based on an Entity member. This functionality gives users more customization to display data precisely regardless of a Screen Selection. Under the "**Refer to**" subpage of Block settings, it is possible to apply the "Refer to" function to a Data Block with a Cube in order to alter its aggregation or detail level. The "Refer to" function refers the Data Block to a specific Entity member, overriding the Screen Selection (Select) and the axes settings. To do so, click on the "ADD REFER TO" button, select an Entity from the popup window, and then select the desired Entity member. > [!NOTE] > *If the "Refer to" function is enabled, any existing* [*security selection*](/v1/docs/the-database-security-section#database-profile-options) *applied on the Entity chosen in the "Refer to" function configuration will be ignored.* **Example** If you set a "Refer to" condition on the "California" member of the State Entity, the function will return data for that state regardless of rows, columns, and selection settings as shown below: ![contents/assets/images/assets/images/Refer-to-california.png](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/about-data-block-settings-image-ipdblxg0.png) Below is the configuration in the Layout Editor: ![contents/assets/images/block.setting.refer.to.add.png](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/about-data-block-settings-image-zsz1vu5c.png) And, how it appears once the "Refer to" has been applied: ![contents/assets/images/block.setting.refer.to.applied.png](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/about-data-block-settings-image-zi5fs6ri.png) ### More information about “Refer to” There are **no limitations on the number of "Refer to" conditions** you can configure on a Data Block, as long as they don't limit each other. **For example**, if you set a "Refer to" condition on the "Italy" member of the Country Entity and then you set another condition on the "San Francisco" member of the City Entity, you will have empty cells as a result. The "Refer to" function can also be used to **obtain totals**: if you configure a "Refer to" condition on an Entity that is more aggregate than the Entities set By Row or By Column, the function returns the referred occurrence value. **For example**, if you set a "Refer to" condition on the Year and State Entity in a Layout where the Month and City Entities are set by column and row respectively, the function will return the total value for the referred year and state in all cells. **Example:** ![contents/assets/images/assets/images/Refto-cali.png](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/about-data-block-settings-image-cwdos9kf.png) Here's the configuration in the Layout Editor: ![contents/assets/images/block.setting.refer.to.eg.2.gif](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/data.block.settings.refer.to.new.gif) ###