The pivot table component followed the accessibility guidelines and standards, including ADA, Section 508, WCAG 2.2 standards, and WCAG roles that are commonly used to evaluate accessibility.
The accessibility compliance for the pivot table component is outlined below.
- All features of the component meet the requirement.
- Some features of the component do not meet the requirement.
- The component does not meet the requirement.
WAI-ARIA attributes
WAI-ARIA (Accessibility Initiative – Accessible Rich Internet Applications) defines a way to increase the accessibility of web pages, dynamic content, and user interface components developed with Ajax, HTML, JavaScript,and related technologies. ARIA provides additional semantics to describe the role, state, and functionality of web components. The following ARIA attributes are used in the pivot table component:
Attributes
Purpose
role=grid
Attribute added to identify the grid component element within the pivot table element.
role=region
Attribute added to identify the chart component element within the pivot table element.
role=button
This attribute is added to the pager navigation buttons as well as the buttons in the dialog popup such as field list, calculated field, member editor, conditional formatting of pivot table component to indicate that it is a clickable element.
role=table
This attribute is added to each conditional formatting style container element to denote it as a table.
role=tableItems
This attribute is added to the container element that appears inside the number formatting popup to indicate it as a table.
aria-disabled
The buttons within the dialog popups, such as field list, calculated field and member editor, will be disabled based on their usability. To indicate its disabled state, we will add this attribute with the values true. By default, the attribute value is set to false.
aria-label
This attribute is added to label elements that are placed inside the pager, member editor popup, and calculated field popup to identify them as label elements.
aria-selected
This attribute is added to the selected treeview item in the calculated field popup with the value as true to denote that it is a selected element.
aria-colspan
This attribute is added to the th elements in the e-table, which represent the column span value.
aria-rowspan
This attribute is added to the th elements in the e-table, which represent the row span value.
data-type
This attribute is added to the treeview item in the calculated field popup, as well as the buttons in the grouping bar and field list. It represents the aggregate type for the specified field.
data-caption
This attribute is added to the treeview item in the calculated field popup, as well as the buttons in the grouping bar and field list. It represents the caption for the specified field.
data-basefield
This attribute is added to the treeview item in the calculated field popup, as well as the buttons in the grouping bar and field list. It denotes the base field for the specified field, which is used to display the values for aggregation types such as DifferenceFrom, PercentageOfDifferenceFrom, and PercentageOfParentTotal.
data-baseitem
This attribute is added to the treeview item in the calculated field popup, as well as the buttons in the grouping bar and field list. It denotes the base item for the specified field, which is used to display the values for aggregation types such as DifferenceFrom, PercentageOfDifferenceFrom, and PercentageOfParentTotal.
data-field
This attribute is added to the treeview item in the calculated field popup. It denotes the name of the specified field.
data-membertype
This attribute is added to the treeview item in the calculated field popup. It denotes the member type of the selected OLAP calculated field.
data-hierarchy
This attribute is added to the treeview item in the calculated field popup. It denotes the parent hierarchy unique name of the selected OLAP calculated field.
data-formula
This attribute is added to the treeview item in the calculated field popup. It denotes the formula used for the specified calculated field.
data-formatString
This attribute is added to the treeview item in the calculated field popup. It denotes the format string used for the specified calculated field.
data-customformatstring
This attribute is added to the treeview item in the calculated field popup. It denotes the custom format string used for the specified calculated field.
Keyboard interaction
The pivot table component followed the keyboard interaction guideline, making it easy for people who use assistive technologies (AT) and those who completely rely on keyboard navigation. The following keyboard shortcuts are supported by the Message component.
Press
To do this
Tab / Shift + Tab
To focus the close icon in the message.
Enter / Space
Closes the focused close icon’s message.
Pivot Table
Press
To do this
Tab
Moves the cell focus right side. If no cells are focused, it moves to the next active element in the browser page.
Shift + Tab
Moves the cell focus left side. If no cells are focused, it moves to the previous active element in the browser page.
DownArrow
Moves the cell focus downwards. If the selection is enabled in the pivot table, then it will move downwards to select next row or column or individual cell.
UpArrow
Moves the cell focus upwards. If the selection is enabled in the pivot table, then it will move upwards to select previous row or column or individual cell.
LeftArrow
Moves the cell focus left side. If the selection is enabled in the pivot table, then it will move left side to select previous row or column or individual cell.
RightArrow
Moves the cell focus right side. If the selection is enabled in the pivot table, then it will move right side to select next row or column or individual cell.
Shift + DownArrow
Extends the cell selection downwards.
Shift + UpArrow
Extends the cell selection selection upwards.
Shift + LeftArrow
Extends the cell selection to the left side.
Shift + RightArrow
Extends the cell selection to the right side.
Ctrl + A
Selects all cells.
Esc
Deselects all cells. If the current active element is a context menu, then the context menu popup will be closed.
Home
Goes to the first cell in the current row.
End
Goes to the last cell in the current row.
Ctrl + Home
Goes to the first cell in the table.
Ctrl + End
Goes to the last cell in the table.
Enter
If the current cell is an expand/collapse cell, it performs expand/collapse operation (drill operation). If the current row/column header is in value sort state, it performs value sorting. If the current cell is in selection state, it moves to the next row, column or individual cell. If drill-through or editing is enabled in the pivot table, the drill-through dialog will be opened based on the selected value cell. If the current active element is a context menu popup, menu selection will be performed.
Shift + Enter
If value sorting is enabled in the pivot table and the current cell is a header with respect to its value axis, it performs value sorting to either ascending or descending order. If the current cell is in selection state, it moves to the previous row, column or individual cell.
Ctrl + Enter
If hyperlink is enabled in the current cell, it performs hyperlink selection.
Shift + F10 or Menu
If context menu is enabled in the pivot table, the context menu popup will be opened in the current cell.
Field List
Press
To do this
Shift + Ctrl + F
If the popup field list is enabled in either the pivot table or the pivot chart, the field list dialog will be opened.
Tab
Moves to the next active element in the field list. If no active elements present, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element in the field list. If no active elements present, it moves to the previous active element in the browser page.
Shift + F
If the current active element is a field’s button and if it has a filter icon, the filter dialog will open to perform filtering.
Shift + S
If the current active element is a field’s button and if it has a sort icon, the sorting will be performed to the selected field.
Shift + E
If the current active element is a calculated field’s button and if it has an edit icon, the calculated field dialog will be opened to perform editing the selected calculated field.
Enter
Performs the selection operation of the current active element. If the current active element is a field’s button and it has a dropdown icon, the aggregation menu will open to perform calculations using aggregation options to the selected value field.
Delete
If the current active element is a field’s button, the selected field will be removed from the current report.
DownArrow
If the current active element is a tree node, it moves to the next node.
UpArrow
If the current active element is a tree node, it moves to the previous node.
LeftArrow
If the current active element is a tree node, it collapses the current node.
RightArrow
If the current active element is a tree node, it expands the current node.
Home
If the current active element is a tree node, it goes to the first node.
End
If the current active element is a tree node, it goes to the last node.
Space
If the current active element is a tree node or a checkbox element, it will be either checked or unchecked.
Esc or Escape
Closes the popup field list dialog.
Grouping Bar
Press
To do this
Tab
Moves to the next active element (field’s button) in the grouping bar. If no active elements present, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element (field’s button) in the grouping bar. If no active elements present, it moves to the previous active element in the browser page.
Shift + F
If the current active element is a field’s button and if it has a filter icon, the filter dialog will be opened to perform filtering.
Shift + S
If the current active element is a field’s button and if it has a sort icon, the sorting will be performed to the selected field.
Shift + E
If the current active element is a calculated field’s button and if it has an edit icon, the calculated field dialog will be opened to perform editing the selected calculated field.
Enter
Performs the selection operation of the current active element. If the current active element is a field’s button and if it has a dropdown icon, the aggregation menu will be opened to perform calculations using aggregation options to the selected value field.
Delete
If the current active element is a field’s button, the selected field will be removed from the current report.
DownArrow
If the current active element is a dropdown list, the next item will be selected.
UpArrow
If the current active element is a dropdown list, the previous item will be selected.
Home
If the current active element is a dropdown list, the first item will be selected.
End
If the current active element is a dropdown list, the last item will be selected.
Alt + Down
If the current active element is a dropdown list, the popup will be opened.
Alt + Down
If the current active element is a dropdown list, the popup will be closed.
Esc or Escape
Closes the dropdown list.
Filter Dialog
Press
To do this
Shift + F
If the current active element is a field’s button and if it has a filter icon in either the field list or grouping bar UI, the filter dialog will be opened to perform filtering.
Tab
Moves to the next active element in the filter dialog. If no active elements present, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element in the filter dialog. If no active elements present, it moves to the previous active element in the browser page.
DownArrow
If the current active element is a tree node, it moves to the next node.
UpArrow
If the current active element is a tree node, it moves to the previous node.
LeftArrow
If the current active element is a tree node, it collapses the current node. If the current active element is a tab, it moves focus to the previous tab element.
RightArrow
If the current active element is a tree node, it expands the current node. If the current active element is a tab, it moves focus to the next tab element.
Home
If the current active element is a tree node, it goes to the first node.
End
If the current active element is a tree node, it goes to the last node.
Space
If the current active element is a tree node or a checkbox element, it will be either checked or unchecked.
Alt + Down
If the current active element is a DropDownList or DatePicker or DateTimePicker, the popup will be opened.
Alt + Up
If the current active element is a DropDownList or DatePicker or DateTimePicker, the popup will be closed.
Enter
Performs the selection operation of the current active element. If the current active element is a tab, the current tab element will be selected. If the current active element is a tree node, the current node will be either checked or unchecked. If the current active element is DropDownList, the focus item will be selected, and the popup list will close when it is open. Otherwise, toggles the popup list.
Esc or Escape
Closes the filter dialog.
Calculated Field Dialog
Press
To do this
Shift + E
If the current active element is a field’s button and if it has an edit icon in either the field list or grouping bar UI, the calculated field dialog will be opened to perform editing the selected calculated field.
Tab
Moves to the next active element in the calculated field dialog. If no active elements present, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element in the calculated field dialog. If no active elements present, it moves to the previous active element in the browser page.
DownArrow
If the current active element is a tree node, it moves to the next node.
UpArrow
If the current active element is a tree node, it moves to the previous node.
LeftArrow
If the current active element is a tree node, it collapses the current node.
RightArrow
If the current active element is a tree node, it expands the current node. If the current active element is a tree node and has a menu icon, the aggregation menu will be opened to select appropriate aggregation type to the selected field.
Home
If the current active element is a tree node, it goes to the first node.
End
If the current active element is a tree node, it goes to the last node.
Enter
Performs the selection operation of the current active element. If the current active element is a tree node, it copies the selected field name/formula to the formula text area to perform calculations.
Esc or Escape
Closes the calculated field dialog.
Formatting Dialog
Press
To do this
Tab
Moves to the next active element in the formatting dialog. If no active elements present, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element in the formatting dialog. If no active elements present, it moves to the previous active element in the browser page.
DownArrow
If the current active element is a DropDownList, the next item will be selected.
UpArrow
If the current active element is a DropDownList, the previous item will be selected.
Home
If the current active element is a DropDownList, the first item will be selected.
End
If the current active element is a DropDownList, the last item will be selected.
Alt + Down
If the current active element is a DropDownList or ColorPicker, the popup will be opened.
Alt + Down
If the current active element is a DropDownList or ColorPicker, the popup will be closed.
Enter
Performs the selection operation of the current active element.
Esc or Escape
Closes the formatting dialog.
Toolbar
Press
To do this
Tab
Moves to the next active option in the toolbar. If no active elements present, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active option in the toolbar. If no active elements present, it moves to the previous active element in the browser page.
Enter
Performs the selection operation of the current active element.
Drill-Through Dialog
Press
To do this
Tab
Moves to the next active element in the drill-through dialog. If the current active element is a Grid cell, it moves the cell focus to right side. If no active elements present, then it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element in the drill-through dialog. If the current active element is a Grid cell, it moves the cell focus to left side, If no active elements present, then it moves to the previous active element in the browser page.
DownArrow
Moves the row/cell focus downwards.
UpArrow
Moves the row/cell focus upwards.
LeftArrow
Moves the cell focus left side.
RightArrow
Moves the cell focus right side.
Home
Goes to the first cell in the current row.
End
Goes to the last cell in the current row.
Ctrl + Home
Goes to the first cell in the table.
Ctrl + End
Goes to the last cell in the table.
Enter
Performs the selection operation of the current active element.
Esc or Escape
If the cell is in selected state, the it deselects all rows/cells. If the row/cell is in edit state, it cancels the current entries in the row/cell. If the current active element is not a row/cell, it closes the drill-through dialog.
F2
Initiate editing a row/cell in the data grid.
Insert
Adds a new row/cell in the data grid.
Delete
Removes the selected row in the data grid.
Some commonly used applicable key combinations and their relative functionalities in all dialogs are listed below.
Press
To do this
Tab
Moves to the next active element in the dialog. If either no active elements present in the dialog or an overlay is not present in the dialog, it moves to the next active element in the browser page.
Shift + Tab
Moves to the previous active element in the dialog. If either no active elements present in the dialog or an overlay is not present in the dialog, it moves to the previous active element in the browser page.
Space
If the current active element is a tree node or a checkbox element, it will be either checked or unchecked.
Enter
When the Dialog button or any input (except text area) is in focus state, when pressing the Enter key, the click event associated with the primary button or button will be triggered. The Enter key will not be worked, when the dialog content contains any text area with initial focus.
Esc or Escape
Closes the dialog.
Ensuring accessibility
The pivot table component’s accessibility levels are ensured through an accessibility-checker and axe-core software tools during automated testing.
The accessibility compliance of the pivot table component is shown in the following sample. Open the sample in a new window to evaluate the accessibility of the pivot table component with accessibility tools.
- The component does not meet the requirement.