![]() This option will display the data from both Sales and Stores in a single table. By default, the option Sales and Related Tables will be selected. The below example shows the View Underlying Data table of a report that was created by joining the Sales table and the Stores table. You can also choose to view the individual tables separately. By default, the option displaying the base table along with the related tables will be selected. In case you have created a Pivot by joining two or more tables then you can view the underlying data by selecting the tables from the View Data From drop-down. ![]() The following screen-shot describes how underlying sales data will be displayed when you click on the relevant data point in the Pivot Table. You can also view the overall data by clicking the option View Underlying Data in the toolbar. Clicking your mouse over a cell in the selected Pivot Table will display its underlying data in a pop-up table. You can click on any cell in the Pivot Table to view its underlying data in a pop-up table. Zoho Analytics provides an option to view (drill into) the data that makes up the Pivot Table using the option called View Underlying Data. Note: This option is supported only for a multiple-rows Pivot View. Expand/Collapse entire : This option will expand/collapse the entire column.Expand/Collapse each : This option will expand/collapse all cells with the same cell name in the column.Expand/Collapse : This option will expand/collapse all the cells available underneath the selected cell.This performs the same function as the Expand/Collapse option in the toolbar. Expand/Collapse All: Click this option if you wish to expand/collapse the entire Pivot table.When you click this option, your entire Pivot will be in either Expand mode or Collapse mode.Īpart from the Expand All and Collapse All option, you can also perform the following actions by right-clicking a specific cell: The Expand/Collapse option in the toolbar is for the entire Pivot. ![]() The (+/-) icons will be displayed on the left side of a row heading in the pivot. You can expand and collapse rows in a multiple-rows Pivot View by clicking the Expand/Collapse icon available in the toolbar or by right-clicking a specific cell in the Pivot table. You can choose to display the expand or collapse (+/-) icons in a Pivot View using the Expand/Collapse option available under the Layout Settings. i.e., the users can view the higher group and gradually move to the groups within or do the reverse. This feature works in a hierarchical manner. Using this option, a Pivot table user or a viewer can further explore and understand the data in a Pivot View. This option allows you to further drill-down your Pivot table. Expand/Collapse OptionĮxpand/Collapse in a Pivot View is a handy feature that provides additional flexibility to the users. Refer to the topic Sorting a Pivot Table to know how to sort your Pivot Table data. In Zoho Analytics, Pivot Table can be sorted by its corresponding column values, data values and summary values. In this section, we will discuss each of these options in detail. The options include Expand/Collapse, Viewing Underlying data, sorting, exporting, sharing and publishing a Pivot Table. Zoho Analytics offers a wide range of interactive options on a Pivot Table when accessed by an end-user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |