![]() For example, categories will be expanded starting with the second, and products in these categories will only be if their names match. Secondly, you can define a condition of data expanding for each drill-down level.In other words, when more than one data column is added to the Rows and Columns fields First, the ability to expand is relevant only when data detailing is formed in a pivot table.Important to know!īefore we take a closer look at the Condition editor, the two moments should be mentioned. Conditions of drill-down values of rows or columns are formed in a special editor. In other words, when carrying out a condition, a header of a row or column may be detailed, i.e., expanded automatically when viewing a dashboard. Now you can define a condition of expanding by default. When viewing a dashboard in the viewer or the Preview tab, you can expand a header to detail by clicking on it. As it was mentioned above, by default, the Ascending sorting mode is applied to all headers of rows and columns.īy default, all values of rows and columns are collapsed when there is detail. For example, you can use the Descending direction for parent headers, the Ascending direction for child headers, and without sorting for sub-detail headers. ![]() By selecting each data column in the element editor and changing the value of the Sort Direction property, you can achieve the result you need. Here it's important to understand that if a pivot table contains several detailing columns for rows and columns, you can define the sort direction of headers for each of them. ![]() Now let's take a step back and investigate the topic of sorting for detailing fields. ![]() You can read about how to create a drill down in the Pivot Table element in the documentation. To create headers with detailing, you should add several data columns to the Rows and Columns fields of the Pivot Table element. You should know that there is a nuance associated with the sort direction of detailed data in rows and columns, but about that a little later.ĭrilling down in a pivot table does not mean moving to a new data view (another dashboard, report, element) but expanding the row or column header where detailed values are located. To change the sort direction of the headers of rows and columns, you should open the Pivot Table editor, select a data column in an appropriate field, and set a necessary value for the Sort Direction property. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |