There are numerous parameters to improve the appearance of pivot tables. Based on the type of data and its presentation, various layout options are available. With the Compact Form, developers can optimize readability by keeping related data in one column. Using the Outline Form allows each row field to reside in a separate column – displaying one column per field and providing space for field headers.
Tabular Form’s traditional table format is perceptive for users and includes field headers in each column – allowing developers to repeat item labels. Customers can also reuse the pivot table data in a new location for further analysis.
In addition to the pivot options, the AutofitColumn feature adjusts the pivot table layout for a better appearance. For example, it automatically changes the column width to accommodate the longest value in a field. With Pivot ContextMenu, end-users can apply sorting, reorder field headers, and customize the control by expanding and collapsing field values with a compact and intuitive UI.