The following modifications can be made to the way data is displayed in the pivot table. Indent Level:В You can change the indent level of the data displayed in the compact Row Labels column, that groups and displays the values dropped in the Row shelf.В By default, indent level 1 will be applied. The following modification can be made to the Compact layout. Repeat group level value in each row:В Select this option to display the group label for every row listed in your pivot table. The following modification can be made to the Tabular layout. To learn more about the layout options, click here. To customize these layout options, click the SettingsВ icon on the top right corner of your pivot table, and navigate to the LayoutВ tab. Zoho Analytics allows you to choose one of two layout options for your pivot tables. You can specify an alternate value that could be displayed instead of this in the Display 'Unknown' value as field. Null or empty value present in the underlying data of the pivot will be displayed as -No Value-В by default.You could also choose to apply this new width to the already resized columns using the Apply to manually resized columns check box.You can uniformly resize the columns by selecting the Set default column width to checkbox and then specify the required width in pixel in the provided field.In case you wish to repeat the group label for each row, check the Repeat group label value in each row checkbox.Under the Layout & Display section, you can choose to display the index number for the rows by selecting Hide row numbers check box.In the General Tab,В s pecify the title and description in the corresponding fields.You will notice that this dialog contains two tabs - General and Format Select Settings option in the toolbar.Open the Pivot Table you would like to customize.To customize the appearance of the Pivot, follow the steps given below: Zoho Analytics offers options to both customize the elements inside the Pivot (hide row numbers, wrap text in header etc) as well as enhance the complete look and feel of the Pivot Table by applying Themes. Zoho Analytics allows you to customize the look and feel of your Pivot Table. In this section we will discuss about various options provided by Zoho Analytics to customize a Pivot Table that you create. When designing a Pivot Table, Zoho Analytics offers a wide range of options to customize it and improve the overall appearance in different ways.

Pivot table background color