{"id":33034,"date":"2017-11-09T10:28:43","date_gmt":"2017-11-09T02:28:43","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=33034"},"modified":"2018-10-12T16:22:38","modified_gmt":"2018-10-12T08:22:38","slug":"table-layout-4-5-3","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/table-layout-4-5-3\/","title":{"rendered":"Table Layout (4.5.3)"},"content":{"rendered":"\n<p class=\"left-bar\">This article applies to versions 4.5.0-4.5.3 of P2 Explorer. For the latest, see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/\">Table Layout<\/a>.<\/p>\n<p class=\"overview\">The Table Layout is a component that arranges your data in a tabular format. You only need to configure the first row on the table and that will be repeated across each row in your dataset.<\/p>\n<p class=\"intro-text\">The Table Layout content isn\u2019t restricted to its own data; you can add other components to the layout, and configure them to use the table layout's data as contextual data. For example, if your table layout's data contains production figures for a group of entities, you can add a sparkline chart to the table layout, that shows a trend of production data for the entity in its row. This is covered in <a href=\"#Tutorial_2_Sparkline_on_a_Table_Layout\">Tutorial 2<\/a>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20553 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2.png\" width=\"494\" height=\"191\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2.png 494w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-150x58.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-36x14.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Example-of-a-Table-Layout-2-48x19.png 48w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/a><\/p>\n<table style=\"width: 700px; border: 1px solid #cccccc;\">\n<tbody>\n<tr>\n<td style=\"width: 40%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p>Examples of components you can add to a table layout:<\/p>\n<\/td>\n<td style=\"width: 60%; padding-left: 10px;\">\n<p>Example of a table layout that includes a status indicator component:<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 35%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<ul class=\"intro-text\">\n<li><a title=\"Chart Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/charts\/\">Chart<\/a><\/li>\n<li><a title=\"Data Label Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/data-label\/\">Data Label<\/a><\/li>\n<li><a title=\"Text Label Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/text-label\/\">Text Label<\/a><\/li>\n<li><a title=\"Hyperlink Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/hyperlink\/\">Hyperlink<\/a><\/li>\n<li><a title=\"Status Indicator Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/status-indicator\/\">Status Indicator<\/a><\/li>\n<li><a title=\"Image Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/image\/\">Image<\/a><\/li>\n<li><a title=\"Target Variance Bar Tutorial\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/target-variance-bar\/\">Target Variance Bar<\/a><\/li>\n<li><a title=\"Bullet Graph\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/\">Bullet Graph<\/a><\/li>\n<\/ul>\n<\/td>\n<td>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2.png\" rel=\"lightbox-1\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31374 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2.png\" alt=\"\" width=\"412\" height=\"198\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2.png 412w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2-150x72.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2-24x12.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2-36x17.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-Pic-2-48x23.png 48w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 class=\"page-subheading\">Overview<\/h2>\n<p class=\"no-toc-heading\">The Table Layout<\/p>\n<p class=\"intro-text\">Below is an example of a configured table layout, in design mode:<\/p>\n<p class=\"intro-text\"><strong>1.<\/strong> The Table Layout's data determines the rows and the contextual data. When you assign this data, the first five columns (or fewer, if the dataset has fewer columns) are added automatically.<\/p>\n<p class=\"intro-text\"><strong>2.<\/strong> Choose general appearance here: highlighting and showing\/hiding headers. Note that the style you use must have an Alternate Background Colour for this to show.<\/p>\n<p class=\"intro-text\"><strong>3.<\/strong> The automatically added columns. You can update the header and width for these.<\/p>\n<p class=\"intro-text\"><strong>4.<\/strong>\u00a0In this example, the final column has been manually added, and a Status Indicator component placed on the column. You cannot see the Status Indicator in the table layout properties, as it is a separate component.<\/p>\n<p class=\"intro-text\"><strong>5.<\/strong> The applied style has a colour for\u00a0Alternate Background Colour so that the Highlight shows up.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview.png\" rel=\"lightbox-2\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31384 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview.png\" alt=\"\" width=\"785\" height=\"665\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview.png 785w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-768x651.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-150x127.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-24x20.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-36x30.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Overview-48x41.png 48w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Columns on the Table Layout<\/p>\n<p class=\"note\">Click on a column to see what component is there.<\/p>\n<p class=\"intro-text\"><strong>6. <\/strong> Columns that are added automatically use a Text Label component.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout.png\" rel=\"lightbox-3\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31387 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout.png\" alt=\"\" width=\"787\" height=\"443\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout.png 787w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout-768x432.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout-150x84.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Text-Label-in-Table-Layout-48x27.png 48w\" sizes=\"auto, (max-width: 787px) 100vw, 787px\" \/><\/a><\/p>\n<p class=\"intro-text\"><strong>7. <\/strong> This extra column has a Status Indicator component on it.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout.png\" rel=\"lightbox-4\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31386 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout.png\" alt=\"\" width=\"787\" height=\"603\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout.png 787w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout-768x588.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout-150x115.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout-24x18.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout-36x28.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Status-Indicator-in-Table-Layout-48x37.png 48w\" sizes=\"auto, (max-width: 787px) 100vw, 787px\" \/><\/a><\/p>\n<hr \/>\n<h2 class=\"page-subheading\">Working with the Table Layout and its Columns<\/h2>\n<p class=\"intro-text\">To set up a Table Layout, choose data. Then, configure the columns and add new ones. This is described below in the following sections.<\/p>\n<h3>Accessing the Table Layout<\/h3>\n<p class=\"intro-text\">To configure the Table Layout, you first need to select the component. Because the Table Layout is overlaid with components, you can either access it by clicking on an empty column, or use the right-click menu.<\/p>\n<p class=\"intro-text\">1. Right-click on any component on the Table Layout to open the pop-up menu.<\/p>\n<p class=\"intro-text\">2. Click the <strong>Table Layout<\/strong> item, which is second on the list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout.png\" rel=\"lightbox-5\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31391 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout.png\" alt=\"\" width=\"301\" height=\"189\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout.png 301w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout-150x94.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout-24x15.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout-36x23.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-Table-Layout-48x30.png 48w\" sizes=\"auto, (max-width: 301px) 100vw, 301px\" \/><\/a><\/p>\n<p class=\"intro-text\">Now that you have selected the Table Layout, you can reposition it, resize it, and configure it.<\/p>\n<h3>Adding the Data<\/h3>\n<p class=\"intro-text\">There are four data categories to choose from. See: <a title=\"Setting up data for the Table Layout\" href=\"#Setting_up_Data_for_the_Table_Layout\">Setting up data for the Table Layout<\/a>.<\/p>\n<ul class=\"intro-text\">\n<li>Dataset Query<\/li>\n<li>Ad hoc Calculations<\/li>\n<li>Attributes<\/li>\n<li>Tags<\/li>\n<\/ul>\n<h3>Adding and Removing Columns<\/h3>\n<p class=\"intro-text\"><strong>To add a column:<\/strong> Click <strong>Add <\/strong>to add a column, then type in a <em>Header <\/em>and optionally adjust the <em>Width.<\/em><\/p>\n<p class=\"intro-text\"><strong>To remove a column:<\/strong> Click the <strong>Remove<\/strong> button alongside the column.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2.png\" rel=\"lightbox-6\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31394 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2.png\" alt=\"\" width=\"370\" height=\"272\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2.png 370w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2-150x110.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2-24x18.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2-36x26.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-and-remove-columns-2-48x35.png 48w\" sizes=\"auto, (max-width: 370px) 100vw, 370px\" \/><\/a><\/p>\n<h3>Configuring Columns<\/h3>\n<p class=\"intro-text\"><strong>Header:<\/strong> Edit a header by typing over it, or type in a header for a new column.<\/p>\n<p class=\"intro-text\"><strong>Width:<\/strong> Each new column has an asterisk <strong>*<\/strong> as its default width. All columns that use this asterisk for their width have an equal portion of their collective width. Columns that have a number (for example, 100), have a width of that number of pixels (for example, 100 pixels).<\/p>\n<p class=\"note\">Resize the Table Layout component if you need more space for columns.<\/p>\n<h3>Configuring a Column's Component<\/h3>\n<p class=\"intro-text\"><strong>1. <\/strong>Select a column to configure the component positioned on it.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout.png\" rel=\"lightbox-7\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31395 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout.png\" alt=\"\" width=\"428\" height=\"362\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout.png 428w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout-150x127.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout-24x20.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout-36x30.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-component-on-table-layout-48x41.png 48w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><\/a><\/p>\n<p class=\"intro-text\"><strong>2. <\/strong>Now configure the component as you normally would, depending on the component; note that there are some changes to the data you can select (compared to that component on a grid or precision layout), as contextual data is available from the table layout.<\/p>\n<h3>Highlighting Rows or Columns<\/h3>\n<p class=\"intro-text\">You can highlight a table layout's columns or rows, as long as you use a style that has an alternating colour for this.<\/p>\n<p class=\"instruct\">Select an option from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights.png\" rel=\"lightbox-8\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20892 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights.png\" width=\"351\" height=\"217\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights.png 351w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-150x93.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-24x15.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Highlights-48x30.png 48w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/a><\/p>\n<table style=\"width: 900px; border: 1px solid #cccccc;\">\n<tbody>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><strong>Table Layout with Alternate Rows highlighting<\/strong><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><strong>Table Layout with Alternate Columns highlighting<\/strong><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px;\">\n<p><strong>Table Layout with Choose Columns highlighting<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows.png\" rel=\"lightbox-9\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31398 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows.png\" alt=\"\" width=\"300\" height=\"250\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows.png 300w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-150x125.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-24x20.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-36x30.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-48x40.png 48w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight.png\" rel=\"lightbox-10\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31397 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight.png\" alt=\"\" width=\"300\" height=\"250\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight.png 300w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-150x125.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-24x20.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-36x30.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-48x40.png 48w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<td>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights.png\" rel=\"lightbox-11\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31408 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights.png\" alt=\"\" width=\"300\" height=\"250\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights.png 300w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights-150x125.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights-24x20.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights-36x30.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlights-48x40.png 48w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p>Select <em>Alternate Rows<\/em> from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p>Select <em>Alternate Columns<\/em> from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px;\">\n<p>Select <em>Choose Columns <\/em> from the <strong>Highlight<\/strong> drop-down list, then select the <strong>Highlight<\/strong> checkbox next to the columns to highlight.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design.png\" rel=\"lightbox-12\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31404 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design.png\" alt=\"\" width=\"349\" height=\"534\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design.png 349w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design-98x150.png 98w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design-16x24.png 16w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design-24x36.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Rows-Highlight-design-31x48.png 31w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/a><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px; border-right: 1px solid #cccccc;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design.png\" rel=\"lightbox-13\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-31403 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design.png\" alt=\"\" width=\"355\" height=\"531\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design.png 355w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design-100x150.png 100w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design-16x24.png 16w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design-24x36.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Alternate-Columns-Highlight-Design-32x48.png 32w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/a><\/p>\n<\/td>\n<td style=\"width: 33%; padding-left: 10px;\">\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlight-design.png\" rel=\"lightbox-14\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31402 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Choose-columns-highlight-design.png\" alt=\"\" width=\"351\" height=\"528\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"instruct\">To clear highlighting, select <em>None<\/em> from the <strong>Highlight<\/strong> drop-down list.<\/p>\n<h3>Hiding the Headers<\/h3>\n<p class=\"intro-text\">To hide the table layout headers, select the <strong>Headerless<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless.png\" rel=\"lightbox-15\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31406 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless.png\" alt=\"\" width=\"353\" height=\"316\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless.png 353w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless-150x134.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless-24x21.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless-36x32.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Select-Headerless-48x43.png 48w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<h3>Styling the Table Layout<\/h3>\n<p class=\"intro-text\">First style the table layout, by selecting a style from the drop-down list. If you are a Style Administrator, you can add a new <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-admin\/explorer-styles\/styling-layouts\/\">Table Layout style<\/a>.<\/p>\n<p class=\"intro-text\">Next, click on each of the column components and style these to work well as a group, for example to get consistent sizes and alignments.<\/p>\n<hr \/>\n<h2 class=\"page-subheading\">The Table Layout's Data<\/h2>\n<p class=\"intro-text\">When you have assigned data to a new table layout, the first five data columns are automatically added as columns on the Table Layout, each with a Text Label component containing data for one of the five data columns. The number of rows depends on the dataset: if the dataset has ten rows, the Table Layout will have ten rows, and so on.<\/p>\n<p class=\"intro-text\">Many of the components that you want to add to the Table Layout have access to the data. For example:<\/p>\n<ul class=\"intro-text\">\n<li>Drop an Image component onto a Table Layout column, and configure its conditions to use contextual Table Layout data.<\/li>\n<li>Drop a Data Label component onto a Table Layout column, and configure its <em>Value<\/em> to use contextual Table Layout data.<\/li>\n<li>Drop a Target Variance Bar component onto a Table Layout column, and configure its <em>Actual<\/em> and its <em>Target<\/em> to use contextual Table Layout data.<\/li>\n<\/ul>\n<p class=\"note\"><strong>Note: <\/strong>Contextual data always applies to the <em>current row<\/em>.<\/p>\n<h3>Selecting the Table Layout's Data<\/h3>\n<p class=\"intro-text\">How you choose the Table layout's data depends on the component's property that you are configuring.<\/p>\n<p class=\"intro-text\"><strong>Example 1<\/strong>: Choosing Table Layout data using the <strong>Context<\/strong> option (here we are selecting a table layout data column for the <em>Filter Value<\/em> property of a <em>Line Chart's<\/em> line series).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31410 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Filter-chart-on-context.png\" alt=\"\" width=\"354\" height=\"79\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Filter-chart-on-context.png 354w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Filter-chart-on-context-150x33.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Filter-chart-on-context-24x5.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Filter-chart-on-context-36x8.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Filter-chart-on-context-48x11.png 48w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/p>\n<p class=\"intro-text\"><strong>Example 2:<\/strong> Choosing Table Layout data using the <strong>table layout data<\/strong> <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-16\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon (here we are selecting a table layout data column for the <em>Actual<\/em> property of a <em>Bullet Graph).<\/em><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart.png\" rel=\"lightbox-17\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-31411 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart.png\" alt=\"\" width=\"360\" height=\"131\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart.png 360w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart-150x55.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Use-context-in-bullet-chart-48x17.png 48w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/a><\/p>\n<hr \/>\n<h2 class=\"page-subheading\">Setting up Data for the Table Layout<\/h2>\n<p class=\"intro-text\">There are four separate categories of data that you can select for your table layout's <em>Data<\/em>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data.png\" rel=\"lightbox-18\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31414 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data.png\" alt=\"\" width=\"367\" height=\"304\" \/><\/a><\/p>\n<p class=\"note\"><strong>Note: <\/strong>You can tab through the different data categories, to configure them. The one that is selected when you save the page remains the configured option. Any other configurations will be lost. When you add data, columns are automatically added. If you change the data, these are not updated; it's easiest to add a new Table Layout component if you are going to change the data.<\/p>\n<p class=\"intro-text\">Here is the full reference to the different data categories you can choose for a table layout's data.<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p><strong>Dataset Query Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9576 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/Dataset-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> Configure your table layout's <em>Data<\/em> to use a column from a dataset query: <a title=\"Using Dataset Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Dataset_Data\">Using Dataset Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data-1.png\" rel=\"lightbox-19\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31420 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data-1.png\" alt=\"\" width=\"355\" height=\"466\" \/><\/a><\/p>\n<\/td>\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%;\"><strong>Ad hoc Calculation Columns: <\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9575 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/Ad-Hoc-Calc-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> Configure your table layout's <em>Data<\/em> to use ad hoc calculations: <a title=\"Using Ad hoc Calculation Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Ad_hoc_Calculation_Data\">Using Ad hoc Calculation Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2.png\" rel=\"lightbox-20\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31418 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2.png\" alt=\"\" width=\"348\" height=\"534\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2.png 348w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2-98x150.png 98w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2-16x24.png 16w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2-23x36.png 23w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-data-2-31x48.png 31w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p><strong>Attribute Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17335 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/07\/Attribute-icon.png\" width=\"21\" height=\"19\" \/> Configure your table layout's <em>Data<\/em> to use attributes for one or more entities: <a title=\"Using Attribute Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Attribute_Data\">Using Attribute Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data-3.png\" rel=\"lightbox-21\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31419 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data-3.png\" alt=\"\" width=\"358\" height=\"754\" \/><\/a><\/p>\n<\/td>\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%;\"><strong>Tag Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9573 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/tag-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> Configure your table layout's <em>Data<\/em> to use tags: <a title=\"Using Tag Data\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Tag_Data\">Using Tag Data<\/a><\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data-4.png\" rel=\"lightbox-22\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31417 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-Data-4.png\" alt=\"\" width=\"353\" height=\"531\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 class=\"page-subheading\">Using the Table Layout's Data<\/h2>\n<p class=\"intro-text\">When you configure a component on one of the Table Layout's columns, you can select any of the Table Layout's data columns, provided it is of the relevant type (for example, <em>text<\/em>, <em>number<\/em> and so on).<\/p>\n<p class=\"intro-text\">The data that gets used is contextual for the row.<\/p>\n<p class=\"intro-text\"><strong>Table Layout Data<\/strong> can be identified by the little table layout data <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-16\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon, in the data category options.<\/p>\n<p class=\"intro-text\">For example, the Data Label picutred below is on a Table Layout component; its <strong>Value<\/strong> property can be configured to use data from the Table Layout columns:<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data.png\" rel=\"lightbox-24\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31422 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data.png\" alt=\"\" width=\"363\" height=\"218\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data.png 363w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data-150x90.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-Label-using-contextual-data-48x29.png 48w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p class=\"left-bar\">Follow the example below, to see how Table Layout's data columns are used.<\/p>\n<p class=\"intro-text\">1. A preview of a Table Layout's dataset. Columns highlighted in green are already used in the Table Layout columns (the first five columns). We are going to add <em>WaterPlannedSum<\/em>, highlighted in yellow, to a new Table Layout column.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there.png\" rel=\"lightbox-25\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31423 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there.png\" alt=\"\" width=\"892\" height=\"404\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there.png 892w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there-768x348.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there-150x68.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there-24x11.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there-36x16.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Columns-already-there-48x22.png 48w\" sizes=\"auto, (max-width: 892px) 100vw, 892px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. This is what the Table Layout looks like, before new columns have been added.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout.png\" rel=\"lightbox-26\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31424 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout.png\" alt=\"\" width=\"957\" height=\"558\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout.png 957w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout-768x448.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout-150x87.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout-36x21.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/First-five-columns-in-table-layout-48x28.png 48w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/a><\/p>\n<p class=\"intro-text\">3. We add a new column, by clicking <strong>Add<\/strong>, and type in a header: <em>Water Planned<\/em>. The new column uppers in the Table Layout component.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3.png\" rel=\"lightbox-27\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20721 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3.png\" width=\"921\" height=\"398\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3.png 921w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-768x332.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-150x65.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-36x16.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Using-data-table-data-3-48x21.png 48w\" sizes=\"auto, (max-width: 921px) 100vw, 921px\" \/><\/a><\/p>\n<p class=\"intro-text\">4. Next, we drag and drop a Data Label component from the component toolbox onto the new column in the Table layout component. Note how the component icon is repeated across the different rows.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added.png\" rel=\"lightbox-28\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31427 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added.png\" alt=\"\" width=\"631\" height=\"506\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added.png 631w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added-150x120.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added-24x19.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added-36x29.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-label-added-48x38.png 48w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. We click on the Data Label compomonent to configure it. Click the <strong>Value<\/strong> drop-down list, select the <strong>Value<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-9572 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/02\/Value-Icon.png\" alt=\"\" width=\"20\" height=\"20\" \/> data category (see <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Value_Data\">Using Value Data<\/a>). Next click the <strong>Table Layout Data<\/strong> <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-16\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon, then select the <em>WaterPlannedSum<\/em> column from the drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum.png\" rel=\"lightbox-30\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31428 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum.png\" alt=\"\" width=\"369\" height=\"476\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum.png 369w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum-116x150.png 116w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum-28x36.png 28w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Add-water-planned-sum-37x48.png 37w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><\/a>.<\/p>\n<p class=\"intro-text\">6. The <em>WaterPlannedSum<\/em> value appears on the table layout. Note how it changes per row. If you look back at the data preview screenshot in <strong>Step 1<\/strong> you can see how <em>WaterPlannedSum<\/em> is <i>50,797\u00a0<\/i>for entity <em>Anstey<\/em>, <i>49,923\u00a0<\/i>for <em>Big Red<\/em>, <em>50,278<\/em>\u00a0for <em>Burt<\/em>, etc. The corresponding values are displayed in the Table Layout now, with data integrity maintained for the <strong>row<\/strong>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added.png\" rel=\"lightbox-31\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31429 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added.png\" alt=\"\" width=\"978\" height=\"451\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added.png 978w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added-768x354.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added-150x69.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added-24x11.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added-36x17.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Water-planned-added-48x22.png 48w\" sizes=\"auto, (max-width: 978px) 100vw, 978px\" \/><\/a><\/p>\n<p class=\"intro-text\">7. In the final step, we remove the decimal points, then style and align the Data Label to match the other columns in the Table Layout.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label.png\" rel=\"lightbox-32\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31430 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label.png\" alt=\"\" width=\"969\" height=\"420\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label.png 969w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label-768x333.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label-150x65.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label-36x16.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Style-the-text-label-48x21.png 48w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/a><\/p>\n<hr \/>\n<hr \/>\n<h2 class=\"page-subheading\">Using the Table Layout's Data for Updating a Variable<\/h2>\n<p class=\"intro-text\">You can also configure a Table Layout's data column to update a variable, which can be used by other components, or in <a title=\"Link Action and Variable Mapping\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/link-action-and-variable-mapping\/\"> variable mapping<\/a>.<\/p>\n<p class=\"no-toc-heading\">Updating a Variable from a Table Layout's Data<\/p>\n<p class=\"left-bar\">Follow the example below, to see how this is done. We'll follow on from the previous example.<\/p>\n<p class=\"intro-text\">1. First we add the <em>selectedAsset<\/em>\u00a0text variable in the <a title=\"Default Values\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/default-value\/\">Default Values<\/a> panel, assigning the value 'Anstey'.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/1-Add-default-selected-asset.png\" rel=\"lightbox-33\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31447 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/1-Add-default-selected-asset.png\" alt=\"\" width=\"364\" height=\"550\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Next we add a Text Label, and include the <em>selectedAsset<\/em>\u00a0variable in the <strong>Content<\/strong>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/2-data-label-show-selected-asset-1.png\" rel=\"lightbox-34\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31448 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/2-data-label-show-selected-asset-1.png\" alt=\"\" width=\"376\" height=\"282\" \/><\/a><\/p>\n<p class=\"intro-text\">3. Now we update the Table Layout. For <strong>Row Variable<\/strong>, we select <em>Entity<\/em> from the drop-down list containing all columns from the dataset. For <strong>Selected<\/strong>, we select the <em>selectedAsset<\/em>\u00a0variable from the drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/3-table-layout.png\" rel=\"lightbox-35\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31445 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/3-table-layout.png\" alt=\"\" width=\"367\" height=\"408\" \/><\/a><\/p>\n<p class=\"intro-text\">In preview or display mode, every time we click a row in the Table Layout, the variable updates, as can be seen in the Text Label.<\/p>\n<p class=\"no-toc-heading\">Examples:<\/p>\n<table>\n<tbody>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p>When we click <strong>Big Red<\/strong> in the table layout, the <em>selectedEntity<\/em> variable updates and the text label shows <strong>Big Red<\/strong> as the selected entity.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example.png\" rel=\"lightbox-36\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31452 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example.png\" alt=\"\" width=\"825\" height=\"319\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example.png 825w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example-768x297.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example-150x58.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example-36x14.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Big-red-example-48x19.png 48w\" sizes=\"auto, (max-width: 825px) 100vw, 825px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p>When we click <strong>Maxwell<\/strong> in the table layout, the <em>selectedEntity<\/em> variable updates and the text label shows <strong>Maxwell<\/strong> as the selected entity.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example.png\" rel=\"lightbox-37\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31451 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example.png\" alt=\"\" width=\"828\" height=\"316\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example.png 828w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example-768x293.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example-150x57.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example-36x14.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Maxwell-example-48x18.png 48w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<tr style=\"border: 1px solid #cccccc; border-left: 2px solid #cccccc; border-right: 2px solid #cccccc;\">\n<td style=\"padding-left: 20px; padding-top: 20px; width: 50%; border-right: 2px solid #cccccc;\">\n<p>When we click <strong>Derby<\/strong> in the table layout, the <em>selectedEntity<\/em> variable updates and the text label shows <strong>Derby<\/strong> as the selected entity.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates.png\" rel=\"lightbox-38\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31450 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates.png\" alt=\"\" width=\"828\" height=\"347\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates.png 828w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates-768x322.png 768w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates-150x63.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates-24x10.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates-36x15.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Derby-Updates-48x20.png 48w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 class=\"page-subheading\">Tutorials<\/h2>\n<p class=\"note\">If you're unfamiliar with the process of building pages, read the article\u00a0<a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-create-your-first-page\/building-an-explorer-page\/\">Building an Explorer Page<\/a>.<\/p>\n<p class=\"intro-text\">The following tutorials demonstrate how to add a table layout, assign data to it, and then use that data for components on additional columns. Tutorial 3 shows how to use table layout data to update a variable, that is then used by a different component.<\/p>\n<p class=\"left-bar\"><strong>Note<\/strong>: This configuration uses the <em>Sample Data <\/em>table\u00a0and datasets that can be optionally made available\u00a0during initial installation and setup. If you don't have access to this data, you will need to adjust the configuration to suit your data at your site.<\/p>\n<h3>Tutorial 1: Bullet Graph on a Table Layout<\/h3>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic.png\" rel=\"lightbox-39\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31460 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic.png\" alt=\"\" width=\"476\" height=\"340\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic.png 476w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic-150x107.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic-24x17.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic-36x26.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-design-pic-48x34.png 48w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 1. Prepare the Tutorial Page<\/p>\n<p class=\"left-bar\"><strong>Note: <\/strong>Before you start the tutorial, <a title=\"Preparing an Explorer page for Tutorials (Precision)\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/preparing-an-explorer-page-for-tutorials-precision\/\">prepare a precision layout page in Studio<\/a> and save it with a suitable name, such as <em>Table Layout Tutorial 1 with Bullet Graph<\/em>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Precision-Layout-Page.png\" rel=\"lightbox-40\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-14582 size-medium\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/Precision-Layout-Page-400x270.png\" width=\"400\" height=\"270\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 2. Add a Default Value<\/p>\n<p class=\"intro-text\">Click <strong>Defaults<\/strong> on the Explorer Ribbon, then add a new default in the Defaults Panel.<\/p>\n<p class=\"intro-text\"><em>Name<\/em>: selectedEntities, <em>Type<\/em>: EntityList, <em>Values<\/em>: Anstey, Big Red, Burt, Derby, Maxwell, Tucki.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values.png\" rel=\"lightbox-41\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31458 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values.png\" alt=\"\" width=\"357\" height=\"607\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values.png 357w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values-88x150.png 88w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values-14x24.png 14w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values-21x36.png 21w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-add-default-values-28x48.png 28w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 3. Add a Month Picker<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20805 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker.png\" width=\"95\" height=\"93\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker.png 95w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/month-picker-48x48.png 48w\" sizes=\"auto, (max-width: 95px) 100vw, 95px\" \/><\/p>\n<p class=\"intro-text\">Drag and drop a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/month-picker\/\">Month Picker<\/a> component near the top left corner of the page. The Month Picker is in the Time <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1865 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/timeicon_sm.png\" alt=\"timeicon_sm\" width=\"18\" height=\"17\" \/> group.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker.png\" rel=\"lightbox-42\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20754 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker.png\" width=\"375\" height=\"135\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker.png 375w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-150x54.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-24x9.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-36x13.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-3-month-Picker-48x17.png 48w\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 4. Add a Table Layout<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20803 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout.png\" width=\"92\" height=\"93\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout.png 92w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/table-Layout-48x48.png 48w\" sizes=\"auto, (max-width: 92px) 100vw, 92px\" \/><\/p>\n<p class=\"intro-text\">1. Drag and drop a Table Layout component below the Month Picker, and resize it by dragging the edges. The Table Layout is in the Layout <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20808 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/layout-group.png\" width=\"21\" height=\"19\" \/> group.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1.png\" rel=\"lightbox-43\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20753 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1.png\" width=\"759\" height=\"414\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1.png 759w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-150x82.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-36x20.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Step-4.1-48x26.png 48w\" sizes=\"auto, (max-width: 759px) 100vw, 759px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Click the Table Layout component to configure it.<\/p>\n<p class=\"intro-text\">3. Add a dataset query to the Table Layout's data, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Dataset_Data\">Data Selector for Dataset Queries<\/a>.<\/p>\n<ul class=\"intro-text\">\n<li>Select the <strong>WellProductionDataSumByYear<\/strong> dataset query from the <em>Oil and Gas Data<\/em> datasource (or substitute with your own dataset query).<\/li>\n<li>Select <strong>endTime<\/strong> from the <em>EndDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>endTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<li>Select <strong>selectedEntities<\/strong> from the <em>EntitiesList<\/em> parameter drop-down list (variables). This uses the Default variable that you added in Step 2.<\/li>\n<li>Select <strong>startTime<\/strong> from the <em>startDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>startTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data.png\" rel=\"lightbox-44\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31457 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data.png\" alt=\"\" width=\"366\" height=\"465\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data.png 366w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data-118x150.png 118w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data-28x36.png 28w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/tut-1-Table-Layout-Data-data-38x48.png 38w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/a><\/p>\n<p class=\"intro-text\">The first five columns from the dataset are automatically added to the Table Layout.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns.png\" rel=\"lightbox-45\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31456 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns.png\" alt=\"\" width=\"359\" height=\"574\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns.png 359w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns-94x150.png 94w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns-15x24.png 15w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns-23x36.png 23w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-table-layout-columns-30x48.png 30w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<p class=\"intro-text\">4. Remove the <em>Year, OilPlannedSum<\/em> and <em>GasPlannedSum<\/em> columns (click the <strong>Remove<\/strong> button next to each), and rename <em>OilActualSum<\/em> to <em>Oil Prod<\/em> (type in the <strong>Header<\/strong> edit box).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns.png\" rel=\"lightbox-46\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31504 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns.png\" alt=\"\" width=\"360\" height=\"581\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns.png 360w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns-93x150.png 93w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns-15x24.png 15w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns-22x36.png 22w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-1-remove-columns-30x48.png 30w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. Click <strong>Add<\/strong> to add a new column, and name it <em>Oil Targets<\/em> (type in the <strong>Header<\/strong> text box).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column.png\" rel=\"lightbox-47\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31454 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column.png\" alt=\"\" width=\"364\" height=\"515\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column.png 364w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column-106x150.png 106w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column-17x24.png 17w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column-25x36.png 25w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-1-add-column-34x48.png 34w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 5. Add a Bullet Graph<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20806 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts.png\" width=\"92\" height=\"89\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts.png 92w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Bullet-Charts-48x46.png 48w\" sizes=\"auto, (max-width: 92px) 100vw, 92px\" \/><\/p>\n<p class=\"intro-text\">In this step, we'll add a bullet graph onto the table layout, and then configure its value to use a column from the table layout's data (<em>OilActualSum<\/em>), and compare it to a fixed target value.<\/p>\n<p class=\"intro-text\">1. Drag and drop a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/bullet-graph\/\">Bullet Graph<\/a> component onto the last column of the Table Layout (with the header: <strong>Oil Targets<\/strong>). The Bullet Graph is in the Chart <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" rel=\"lightbox-48\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1837\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" alt=\"chartsicon_sm\" width=\"22\" height=\"17\" \/><\/a> group.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet.png\" rel=\"lightbox-49\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20819 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet.png\" width=\"751\" height=\"403\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet.png 751w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-150x80.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-24x13.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-36x19.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Drag-and-drop-bullet-48x26.png 48w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Add value data to the Bullet Graph's <em>Actual<\/em> property, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Value_Data\">Data Selector for Values<\/a>.<\/p>\n<p class=\"note\"><strong>Note:<\/strong> Because the Bullet Graph is on a Table Layout component, the <em>Value<\/em> data category has the additional data button for Table Layout Data <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-16\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a>. Click the <strong>Table Layout Data<\/strong> <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" rel=\"lightbox-16\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20724 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/Table-Layout-Data-icon.png\" width=\"15\" height=\"13\" \/><\/a> icon, then select the <em>OilActualSum<\/em> column from the drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph.png\" rel=\"lightbox-52\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31461 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph.png\" alt=\"\" width=\"360\" height=\"458\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph.png 360w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph-118x150.png 118w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph-28x36.png 28w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Data-for-bullet-graph-38x48.png 38w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/a><\/p>\n<p class=\"intro-text\">3. Add value data to the Bullet Graph's <em>Target<\/em> property, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Value_Data\">Data Selector for Values<\/a>. Click the <em> numeric constant<\/em> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-20824 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant.png\" width=\"37\" height=\"30\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant.png 37w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant-24x19.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/10\/numeric-constant-36x29.png 36w\" sizes=\"auto, (max-width: 37px) 100vw, 37px\" \/> icon, and type in a number: <em>120000<\/em>.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data.png\" rel=\"lightbox-53\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31462 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data.png\" alt=\"\" width=\"354\" height=\"288\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data.png 354w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data-150x122.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data-24x20.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data-36x29.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Bullet-graph-target-data-48x39.png 48w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 6. Style the Table Layout<\/p>\n<p class=\"intro-text\">In this step, we'll select a style that has wide rows for accommodating the Bullet Graph component. If you are a Style Administrator, you can add a new Table Layout style.<\/p>\n<p class=\"intro-text\">1. Select the Table Layout component: right-click on any component on the Table Layout to open the pop-up menu, then click the <strong>Table Layout<\/strong> option.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1.png\" rel=\"lightbox-54\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31463 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1.png\" alt=\"\" width=\"533\" height=\"376\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1.png 533w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1-150x106.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1-24x17.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1-36x25.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Accessing-the-table-layout-in-tut-1-48x34.png 48w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/a><\/p>\n<p class=\"intro-text\">2. Select a style from the <strong>Style<\/strong> drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style.png\" rel=\"lightbox-55\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31464 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style.png\" alt=\"\" width=\"359\" height=\"658\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style.png 359w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style-82x150.png 82w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style-13x24.png 13w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style-20x36.png 20w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-style-26x48.png 26w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 7. Preview the Page<\/p>\n<ul class=\"intro-text\">\n<li class=\"intro-text\">Click the Preview <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox-56\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a> button on the Studio toolbar to see what your page will look like in run-time.<\/li>\n<li class=\"intro-text\">Select <em>August 2016<\/em> from the month picker.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview.png\" rel=\"lightbox-57\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31465 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview.png\" alt=\"\" width=\"493\" height=\"295\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview.png 493w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview-150x90.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview-24x14.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tabel-Layout-in-Preview-48x29.png 48w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/a><\/p>\n<h3>Tutorial 2: Sparkline on a Table Layout<\/h3>\n<p class=\"intro-text\">In this tutorial, we'll update the Table Layout used in Tutorial 1, and configure it to use a Sparkline instead of a Bullet Graph. The Sparkline we'll configure is a Line Chart component without labels, gridlines, a legend or tooltips.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design.png\" rel=\"lightbox-58\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31489 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design.png\" alt=\"\" width=\"526\" height=\"387\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design.png 526w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design-150x110.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design-24x18.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design-36x26.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-2-in-Design-48x35.png 48w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\" \/><\/a><\/p>\n<p class=\"note\"><strong>Note:<\/strong> If you skipped <a href=\"#Tutorial_1_Bullet_Graph_on_a_Table_Layout\">Tutorial 1<\/a>, you'll need to follow the steps up to step 5.<\/p>\n<p class=\"no-toc-heading\">Step 1. Prepare the Tutorial Page<\/p>\n<p class=\"intro-text\">1. Open the page you created in Tutorial 1 (called <em>Table Layout Tutorial 1 with Bullet Graph<\/em>, or similar).<\/p>\n<p class=\"intro-text\">2. Click <strong>Save As<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13286 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/save-as-button.png\" width=\"21\" height=\"22\" \/> on the Explorer toolbar, and save a copy of the page to your workspace (call it <em>Table Layout Tutorial 2 with Sparkline<\/em>, or similar).<\/p>\n<p class=\"no-toc-heading\">Step 2. Update the Table Layout<\/p>\n<p class=\"intro-text\">1. Select the Table Layout component: right-click on any component on the Table Layout to open the pop-up menu, then click the <strong>Table Layout<\/strong> option.<\/p>\n<p class=\"intro-text\">2. Rename <em>Oil Targets<\/em> (in the third column) to <em>Oil Trend<\/em> (type in the <strong>Header<\/strong> edit box).<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2.png\" rel=\"lightbox-59\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31466 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2.png\" alt=\"\" width=\"361\" height=\"527\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2.png 361w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2-103x150.png 103w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2-16x24.png 16w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2-25x36.png 25w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Table-Layout-in-Tut-2-33x48.png 33w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 3. Add a Line Chart<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/LIne-Chart-Icon.png\" rel=\"lightbox-60\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31513 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/LIne-Chart-Icon.png\" alt=\"\" width=\"91\" height=\"93\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/LIne-Chart-Icon.png 91w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/LIne-Chart-Icon-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/LIne-Chart-Icon-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/LIne-Chart-Icon-48x48.png 48w\" sizes=\"auto, (max-width: 91px) 100vw, 91px\" \/><\/a><\/p>\n<p class=\"intro-text\">In this step, we'll add a line chart onto the table layout, configure it to use its own data, with a filter value using the table layout's data (<em>Entity<\/em>).<\/p>\n<p class=\"intro-text\">1. Drag and drop a <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/charts\/\">Line Chart<\/a> component onto the last column of the Table Layout (with the header: <strong>Oil Trend<\/strong>). The Line Chart is in the Chart <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" rel=\"lightbox-61\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1837\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/02\/chartsicon_sm.png\" alt=\"chartsicon_sm\" width=\"22\" height=\"17\" \/><\/a> group.<\/p>\n<p class=\"intro-text\">2. Click the Line Chart component to configure it.<\/p>\n<p class=\"intro-text\">3. Add a dataset query to the Line Chart's data, using the <a title=\"Data Selector\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/data-selector\/#Using_Dataset_Data\">Data Selector for Dataset Queries<\/a>.<\/p>\n<ul class=\"intro-text\">\n<li>Select the <strong>WellProductionSumbyDay<\/strong>\u00a0dataset query from the <em>Oil and Gas Data<\/em> datasource (or substitute with your own dataset query).<\/li>\n<li>Select <strong>endTime<\/strong> from the <em>EndDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>endTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<li>Select <strong>selectedEntities<\/strong> from the <em>EntitiesList<\/em> parameter drop-down list (variables). This uses the Default variable that you added in Step 2 of Tutorial 1.<\/li>\n<li>Select <strong>startTime<\/strong> from the <em>startDate<\/em> parameter drop-down list (variables). This uses the Page Default variable for <em>startTime<\/em>, which gets updated when the users selects a period from the Month picker.<\/li>\n<\/ul>\n<p class=\"note\"><strong>Note:<\/strong> These are the same parameters used for the Table Layout data's dataset query, keeping the two in sync. The dataset queries themselves are also similar, and access the same data; the difference is that the chart's query divides the results into separate days, for showing a Sparkline trend.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Sparkline-data.png\" rel=\"lightbox-62\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31471 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Sparkline-data.png\" alt=\"\" width=\"361\" height=\"442\" \/><\/a><\/p>\n<p class=\"intro-text\">4. Configure the Line Series:<\/p>\n<p class=\"intro-text\">a. Click to open the Line Series.<\/p>\n<p class=\"intro-text\">b. For the <strong>Y Column<\/strong>, select <em>DataColumn<\/em> and <em>OilActualSum<\/em> from the respective drop-down lists.<\/p>\n<p class=\"intro-text\">c. For the <strong>Filter Column<\/strong>, select <em>DataColumn<\/em> and <em>Entity<\/em> from the respective drop-down lists.<\/p>\n<p class=\"intro-text\">d. For the <strong>Filter Value<\/strong>, select <em>Context<\/em> and <em>Entity<\/em> from the respective drop-down lists.<\/p>\n<p class=\"note\"><strong>Note: <\/strong> The <em>Context<\/em> option is available to all of the chart's properties, because it is on a Table Layout component. When you select context data, Explorer uses the selected Y Column for the current row.<\/p>\n<p class=\"intro-text\">e. For the <strong>Colour Matcher<\/strong>, type <em>OIL<\/em>. This colours the trend in green.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline.png\" rel=\"lightbox-63\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31467 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline.png\" alt=\"\" width=\"363\" height=\"609\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline.png 363w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-89x150.png 89w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-14x24.png 14w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-21x36.png 21w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-29x48.png 29w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. Configure the X Axis:<\/p>\n<p class=\"intro-text\">a. Click to open the X Axis.<\/p>\n<p class=\"intro-text\">b. For the <strong>Column<\/strong>, select <em>DataColumn<\/em> and <i>Day\u00a0<\/i>from the respective drop-down lists.<\/p>\n<p class=\"intro-text\">c. Clear the <strong>Visible<\/strong> checkbox, so that the X Values do not appear along the X Axis (there is no space for this, for a Sparkline).<\/p>\n<p class=\"intro-text\">d. Clear the <strong>Enable Gridlines<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis.png\" rel=\"lightbox-64\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31470 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis.png\" alt=\"\" width=\"354\" height=\"364\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis.png 354w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis-146x150.png 146w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-sparkline-X-Axis-48x48.png 48w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p class=\"intro-text\">5. Configure the Left Y Axis:<\/p>\n<p class=\"intro-text\">a. Click to open the Left Y Axis.<\/p>\n<p class=\"intro-text\">b. Clear the <strong>Visible<\/strong> checkbox, so that the y Values do not appear along the Y Axis (there is no space for this, for a Sparkline).<\/p>\n<p class=\"intro-text\">c. Clear the <strong>Enable Gridlines<\/strong> checkbox.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis.png\" rel=\"lightbox-65\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31468 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis.png\" alt=\"\" width=\"356\" height=\"445\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis.png 356w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis-120x150.png 120w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis-19x24.png 19w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis-29x36.png 29w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-left-Y-Axis-38x48.png 38w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/a><\/p>\n<p class=\"intro-text\">In the <strong>Others<\/strong> properties group, the <strong>Legend<\/strong> is cleared by default. Clear the <strong>Tooltip<\/strong> option as well.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend.png\" rel=\"lightbox-66\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31475 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend.png\" alt=\"\" width=\"359\" height=\"185\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend.png 359w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend-150x77.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend-24x12.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend-36x19.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Clear-tooltip-and-legend-48x25.png 48w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 4. Preview the Page<\/p>\n<ul class=\"intro-text\">\n<li class=\"intro-text\">Click the Preview <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox-56\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a> button on the Studio toolbar to see what your page will look like in run-time.<\/li>\n<li class=\"intro-text\">Select <em>September 2016<\/em> from the month picker. \u00a0The sparkline shows daily production figures for the period.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2.png\" rel=\"lightbox-68\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31476 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2.png\" alt=\"\" width=\"464\" height=\"284\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2.png 464w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2-150x92.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2-24x15.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2-36x22.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Preview-mode-for-tutorial-2-48x29.png 48w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<h3>Tutorial 3: Show Variable from Selected Row<\/h3>\n<p class=\"intro-text\">In this tutorial, we'll add a new variable to show the <em>OilPannedSum<\/em> for the selected row.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design.png\" rel=\"lightbox-69\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31481 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design.png\" alt=\"\" width=\"534\" height=\"526\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design.png 534w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design-150x148.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design-36x36.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-in-design-48x48.png 48w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p class=\"note\"><strong>Note:<\/strong> If you skipped <a href=\"#Tutorial_1_Bullet_Graph_on_a_Table_Layout\">Tutorial 1<\/a>, you'll need to follow the steps up to step 5.<\/p>\n<p class=\"no-toc-heading\">Step 1. Prepare the Tutorial Page<\/p>\n<p class=\"intro-text\">1. Open the page you created in Tutorial 1 (called <em>Table Layout Tutorial 1 with Bullet Graph<\/em>, or similar).<\/p>\n<p class=\"intro-text\">2. Click <strong>Save As<\/strong> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13286 size-full\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2016\/04\/save-as-button.png\" width=\"21\" height=\"22\" \/> on the Explorer toolbar, and save a copy of the page to your workspace (call it <em>Table Layout Tutorial 3 with Selected Row<\/em>, or similar).<\/p>\n<p class=\"no-toc-heading\">Step 2. Add a Default Value<\/p>\n<p class=\"intro-text\">Click <strong>Defaults<\/strong> on the Explorer Ribbon, then add a new default in the Defaults Panel.<\/p>\n<p class=\"intro-text\"><em>Name<\/em>: PlannedOil, <em>Type<\/em>: Number, <em>Value<\/em>: 0.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-add-default.png\" rel=\"lightbox-70\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31480 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tutorial-3-add-default.png\" alt=\"\" width=\"360\" height=\"678\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 3. Add and Configure a Text Label<\/p>\n<p class=\"intro-text\">1. Drag and drop a text label below the table layout.<\/p>\n<p class=\"intro-text\">2. Add text: 'Planned Oil:' then click <strong>Add Data<\/strong> and select the new <em>PlannedOil<\/em> variable.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1.png\" rel=\"lightbox-71\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31487 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1.png\" alt=\"\" width=\"370\" height=\"393\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1.png 370w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1-141x150.png 141w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1-24x24.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1-34x36.png 34w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Configure-Text-Label-1-45x48.png 45w\" sizes=\"auto, (max-width: 370px) 100vw, 370px\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 4. Update the Table Layout<\/p>\n<p class=\"intro-text\">1. Select the Table Layout component: right-click on any component on the Table Layout to open the pop-up menu, then click the <strong>Table Layout<\/strong> option.<\/p>\n<p class=\"intro-text\">2. For the <strong>Row Variable<\/strong> property, select <em>OilPlannedSum<\/em> from the drop-down list.<\/p>\n<p class=\"intro-text\">3. For the <strong>Selected<\/strong> property, select <em>PlannedOil<\/em> from the drop-down list.<\/p>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-3-configure-table-layout.png\" rel=\"lightbox-72\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31478 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Tut-3-configure-table-layout.png\" alt=\"\" width=\"361\" height=\"432\" \/><\/a><\/p>\n<p class=\"no-toc-heading\">Step 4. Preview the Page<\/p>\n<ul class=\"intro-text\">\n<li class=\"intro-text\">Click the Preview <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" rel=\"lightbox-56\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2896\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2015\/03\/preview.png\" alt=\"preview\" width=\"13\" height=\"14\" \/><\/a> button on the Studio toolbar to see what your page will look like in run-time.<\/li>\n<li>Select May 2017 from the month picker.<\/li>\n<li class=\"intro-text\">Click on the row that contains entity 'Derby'. See how the <em>PlannedOil<\/em> amount updates in the text label. Now click on another entity and see how the <em>PlannedOil<\/em> changes for that entity.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil.png\" rel=\"lightbox-74\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31493 size-full alignnone\" src=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil.png\" alt=\"\" width=\"594\" height=\"420\" srcset=\"https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil.png 594w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil-150x106.png 150w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil-24x17.png 24w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil-36x25.png 36w, https:\/\/oihelp.corporate.ifs.com\/help\/wp-content\/uploads\/2017\/09\/Planned-oil-48x34.png 48w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<h2 class=\"page-subheading\">Release History<\/h2>\n<ul class=\"intro-text\">\n<li class=\"overview\">Table Layout Label 4.5.3 (this release)\n<ul class=\"overview\">\n<li>If the table layout's data has tags or calculations that have a digital state set assigned, the matching digital state pair's <em>Name<\/em> appears instead of the <em>Value<\/em> if there is a match, in text labels or data labels on the table layout's columns. Read more: <a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-primers\/explorers-data\/#Digital_State_Sets\">Digital State Sets<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"intro-text\">Table Layout 4.5.0\n<ul class=\"intro-text\">\n<li>Optional configuration for updating a page variable with any nominated column from the table layout\u2019s dataset<\/li>\n<\/ul>\n<\/li>\n<li class=\"intro-text\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/table-layout-4-4-1\/\">Table Layout 4.4.1<\/a><\/li>\n<\/ul>\n<p class=\"intro-text\">\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Table Layout is a component that arranges your data in a tabular format. You only need to configure the first row on the table and that will be repeated across each row in your dataset.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/table-layout\/table-layout-4-5-3\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":8,"featured_media":20802,"parent":31334,"menu_order":3,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[11],"tags":[116,113],"class_list":["post-33034","page","type-page","status-publish","has-post-thumbnail","hentry","category-tutorial","tag-layouts","tag-tables","Version-4-5-0","Version-4-5-1","Version-4-5-2","Version-4-5-3","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/33034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=33034"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/33034\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/31334"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/20802"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=33034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=33034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=33034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}