--- title: Grid - Display Options (Up to V6.02) description: Describes grid display options up to V6.02. For version V.6.1 additional functionality was included to allow totals to be added to the bottom of grids. --- [Skip to content](https://help.intuitivebusinessintelligence.com/grid-display-options#main-content) English Show submenu for translations ![Intuitive logo RGB-1.png\]](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20RGB-1.png?height=40&name=Intuitive%20logo%20RGB-1.png) Open main navigation Close main navigation - English Show submenu for translations - [Go to weareintuitive.com](https://weareintuitive.com/) [Go to weareintuitive.com](https://weareintuitive.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.intuitivebusinessintelligence.com/?hsLang=en) 2. [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en) 3. [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components) # Grid - Display Options (Up to V6.02) ## Describes grid display options up to V6.02. For version V.6.1 additional functionality was included to allow totals to be added to the bottom of grids. The look and feel of a grid can be configured using the Display Options Icon ![dash35](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash35.png?width=31&name=dash35.png) A pop-up window appears and the grid can be formatted and configured using the Grid - Display options Screen ![dash72](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash72.png?width=688&name=dash72.png) Note: Changes can be previewed using the '**Apply**' button. Pressing '**OK**' will save the changes. The Display Options screen is divided into numerous sections **1   Sorting** **2   Columns** **3   Dimension** **1  Sorting** - This allows the Grid to be sorted by a column present on the chart. If, for instance, the Grid is to be sorted by 'Accounting Period' then the 'Accounting Period' column would be selected. ![dash73](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash73.png?width=622&name=dash73.png) The sort order can be **ascending** or **descending** or none. ![dash74](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash74.png?width=186&name=dash74.png) The number of results returned (rows displayed) can also be set here using the Results Count field. This option can be used to show 'Top 10' or 'Bottom 10' type results. Typing **zero** will show all results returned. **2   Columns** - A row is shown here for every column in the grid. Here you can specify if a column is drillable (tick box) and specify the minimum width of the column (for auto resizing). **2.1 Conditional Formatting** - You can also format columns/rows in the grid by pressing conditional formatting button (Blue +). i.e. You might want to show in green all sales above £1000.  ![dash52-1](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash52-1.png?width=38&name=dash52-1.png) **2.1.1 Condition** - You can specify the condition under which the formats will be applied. ![dash75-1](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash75-1.png?width=688&name=dash75-1.png) For numeric values you can specify a numeric range (Minimum/Maximum) for the condition to be met. For string values the operators (Equals/Contains/Starts With/Ends With) are available. In any case where the condition is met, you can specify the formats to be applied (Bold/Italic/Foreground Colour/Background Colour) and whether the whole row should be highlighted. Note: Multiple conditions can be applied to each column so you cna have different colours applied depending on the condtion being met. Multi-Condition Formatting Example: ![dash76-1](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash76-1.png?width=688&name=dash76-1.png) **![dash77-5](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash77-5.png?width=487&name=dash77-5.png)** **2.2 Delete Columns** - You can also delete a column from the grid using the delete button (Red X) ![dash51](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/dash51.png?width=38&name=dash51.png) **3   Dimension** - Here, you can specify the dimension of the component in pixels. ![sc25](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/sc25.png?width=688&name=sc25.png)   - [Intuitive Dashboards Core Software](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#main-content) - [Getting Started](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#getting-started) - [Viewing Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#viewing-dashboards) - [Interacting with dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#interacting-with-dashboards) - [Filters](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#filters) - [Connections](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#connections) - [Datafeeds](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#datasets) - [Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#components) - [Creating Dashboards and Components - Overview](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-dashboards-and-components-overview) - [Creating Components](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-components) - [Creating a Dashboard](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#creating-a-dashboard) - [Administering the System](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-the-system) - [Administering Users](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-users) - [Administering Groups](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#administering-groups) - [Security Filters - V5.2 and earlier](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-2-and-earlier) - [Security Filters - V5.3 Onward](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#security-filters-v5-3-onward) - [Embedding Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#embedding-dashboards) - [Configuration File](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#configuration-file) - [Installation & Configuration Guide](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#installation-configuration-guide) - [Version History](https://help.intuitivebusinessintelligence.com/intuitive-dashboards-core-software?hsLang=en#version-history) - [Intuitive for PaperCut V2](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#main-content) - [Installing Intuitive for PaperCut](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#installing-intuitive-for-papercut) - [Viewing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#viewing-papercut-dashboards) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut Demonstration Videos](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-demonstration-videos) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-v2?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for PaperCut MF V3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#main-content) - [Installing Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#installing-intuitive-for-papercut-version-3) - [Viewing the dashboards - Intuitive for PaperCut Version 3](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-version-3) - [Editing PaperCut Dashboards](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#editing-papercut-dashboards) - [Intuitive for PaperCut FAQs](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-mf-v3?hsLang=en#intuitive-for-papercut-faqs) - [Intuitive for SAFEQ](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#main-content) - [General Help](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#general-help) - [Software Installation](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#software-installation) - [Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq?hsLang=en#solution-expertise) - [Intuitive For Managed Print Services (MPS)](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#main-content) - [Intuitive for MPS - Overview](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-overview) - [Intuitive for MPS - Installation Steps](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-installation-steps) - [Intuitive for MPS - Import File Layouts](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-import-file-layouts) - [Intuitive For MPS - Loading the Data Warehouse](https://help.intuitivebusinessintelligence.com/intuitive-for-managed-print-services-mps?hsLang=en#intuitive-for-mps-loading-the-data-warehouse) - [Intuitive Cloud Services](https://help.intuitivebusinessintelligence.com/intuitive-cloud-services?hsLang=en) - [Intuitive for PaperCut Hive V1](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#main-content) - [Viewing the dashboards - Intuitive for PaperCut Hive](https://help.intuitivebusinessintelligence.com/intuitive-for-papercut-hive-v1?hsLang=en#viewing-the-dashboards-intuitive-for-papercut-hive) - [Intuitive for SAFEQ Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#main-content) - [Intuitive Solution Expertise](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-solution-expertise) - [Intuitive Software Provisioning](https://help.intuitivebusinessintelligence.com/intuitive-for-safeq-cloud?hsLang=en#intuitive-software-provisioning) - [Intuitive for Docuware](https://help.intuitivebusinessintelligence.com/intuitive-for-docuware?hsLang=en) - [Intuitive for Print Management](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#main-content) - [Solution Knowledge](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#solution-knowledge) - [Technical Information](https://help.intuitivebusinessintelligence.com/intuitive-for-print-management?hsLang=en#technical-information) - [Intuitive for e-BRIDGE Global Print](https://help.intuitivebusinessintelligence.com/intuitive-for-e-bridge-global-print?hsLang=en) - [Intuitive for e-FOLLOW Cloud](https://help.intuitivebusinessintelligence.com/intuitive-for-e-follow-cloud?hsLang=en) - [FAQ](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#main-content) - [Connections](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#connections) - [General Enquiries](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#general-enquiries) - [Datafeeds](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datafeeds) - [Datasets](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#datasets) - [System Compatability](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#system-compatability) - [Software Installation](https://help.intuitivebusinessintelligence.com/faq?hsLang=en#software-installation) [![Chill listening crop-3](https://help.intuitivebusinessintelligence.com/hs-fs/hubfs/Intuitive%20logo%20BLACK.png?width=102&height=24&name=Intuitive%20logo%20BLACK.png "Chill listening crop-3")](https://help.intuitivebusinessintelligence.com?hsLang=en) weareintuitive.com Help Center Copyright © 2026, Intuitive Business Intelligence Limited