![]() ![]() ![]() You can customize your pivot table using the options provided to suit your taste. Zoho Analytics allows you to customize the look and feel of your Pivot table using colorful and attractive themes. By default, -No Value- will be displayed. To apply this width to manually resized columns in the pixel, select the Apply to manually resized column checkbox that appears.ĭisplay 'Unknown' value as: Specify the value that needs to be displayed when the underlying data in the pivot contains empty values. Set default column width to: Enter the column width in pixels that is to applied across all columns in the pivot table. Wrap text in Column headings: Select this option to wrap column headers in the pivot table and display them in multiple lines within the same cell. Hide row numbers: Select this to hide the row numbers displayed in the pivot table. 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. Customizing the pivot table's appearance. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |