Pivot Table Redesign
Pivot Table Redesign
Pivot Table Anatomy
Structure
Data Field
b. Column Field & Controls (Sort & Filer)
c. Row Field & Controls (Sort & Filter)
d. Column Field Items
(i). Primary Column Field Item
(ii). Secondary Column Field Item
e. Row Field Items
(i). Primary Row Field Item
(ii). Secondary Column Field Item
f. Data area
g. Column Grand Total Header
h. Row Grand Total Header
i. Column Grand Total Data
j. Row Grand Total Data
k. Overall Grand Total
Feature Breakdown
Based on competitor analysis and user interviews, we found the basic features like Filter, Sort, Conditional format & User widget are much needed to work on the pivot table report.
Pivot Table Anatomy
Structure
Data Field
Column Field & Controls (Sort & Filter)
Row Field & Controls (Sort & Filter)
Column Field Items
(i). Primary Column Field Item
(ii). Secondary Column Field Item
Row Field Items
(i). Primary Row Field Item
(ii). Secondary Column Field Item
Data area
Column Grand Total Header
Row Grand Total Header
Column Grand Total Data
Row Grand Total Data
Overall Grand Total
Advanced Customization
Customizable Themes
Pivot Table lets users customize colors, fonts, and the overall look, making data presentation visually appealing and personalized.
Pivot Table lets users customize colors, fonts, and the overall look, making data presentation visually appealing and personalized.
Drilldown Data
The drilldown feature easily obtains a list of raw items for a particular value cell or summary cell which can be customised based on need.
The drilldown feature easily obtains a list of raw items for a particular value cell or summary cell which can be customised based on need.
Conditional Formatting
Users can easily change Pivot Table cell values appearance based on conditions.
Users can easily change Pivot Table cell values appearance based on conditions.
Pivot table functions
Custom Sorting
Arrange field headers in column and row axes according to the user-defined order.
Arrange field headers in column and row axes according to the user-defined order.
Filter
The filter feature in Pivot Table allows users to easily select and apply specific criteria to their data. It includes options for searching, selecting multiple items, and applying filters, enabling precise and efficient data analysis.
The filter feature in Pivot Table allows users to easily select and apply specific criteria to their data. It includes options for searching, selecting multiple items, and applying filters, enabling precise and efficient data analysis.
User Widget
The User Widget in Pivot Table displays personalized avatars alongside user names, enhancing visual identification and engagement.
The User Widget in Pivot Table displays personalized avatars alongside user names, enhancing visual identification and engagement.
Pivot Table Interactions
Resize
Resizing allows changing column width at runtime by simply dragging the rightmost boundary of the column header or cell. A scroll bar will appear when the content width exceeds the control width.
Resizing allows changing column width at runtime by simply dragging the rightmost boundary of the column header or cell. A scroll bar will appear when the content width exceeds the control width.
Fixed Header
Pivot Table has row and column headers fixed to compare them with cell values.
Pivot Table has row and column headers fixed to compare them with cell values.
Expandable Rows & Column
Provides built-in expand and collapse capabilities to visualize data in detailed views and abstract views, respectively. By default, the data is displayed in a grouped manner.
Provides built-in expand and collapse capabilities to visualize data in detailed views and abstract views, respectively. By default, the data is displayed in a grouped manner.
Accessability
Right to Left (RTL)
Supports right-to-left rendering and allows the text direction and layout of the control to be displayed from right to left.
Supports right-to-left rendering and allows the text direction and layout of the control to be displayed from right to left.
Adaptation & Responsiveness
Pivot Table has a highly responsive layout and an optimized design for desktops, touchscreens, and smart phones.
Pivot Table has a highly responsive layout and an optimized design for desktops, touchscreens, and smart phones.
