The Dashboard Designer allows you to bind various dashboard items to data in a virtually uniform manner. To learn more, see the Binding Dashboard Items to Data topic.
The only difference is in the data sections that the required dashboard item has. This topic describes how to bind a Pivot dashboard item to data in the Designer.
The Pivot dashboard item has the following data sections.
•The Values section contains data items used to calculate values displayed in the pivot table.
•The Columns section contains data items whose values are used to label columns.
•The Rows section contains data items whose values are used to label rows.
The Pivot dashboard item provides the capability to transpose pivot columns and rows. In this case, data items contained in the Columns section are moved to the Rows section and vice versa.
To transpose the selected Pivot dashboard item, use the Transpose button in the Home ribbon tab.
