To remove the filter, reset the operations in the leftmost column of the Show data where list to (Select Operation). Note: Customize the data in PivotDiagram nodes When you expand a PivotDiagram node, a default set of data is displayed in each node. You can change which numeric data is displayed, the name of that data, and how numeric data is summarized. Show or hide specific data When you show or hide the numeric data (usually a column in your data source), the change is applied to all of the nodes in the selected PivotDiagram. Try it! Select any node of the PivotDiagram. In the PivotDiagram window, under Add Total, select or clear the check boxes for the data that you want to show or hide. In the PivotDiagram window, under Add Total, right-click Sales and choose Avg. Average sales is now displayed on the pivot nodes. Note that this column can also be configured. Change the configuration so that only sales greater than $600 are displayed. Change how numeric data is summarized The default data shown in a PivotDiagram node is the sum of the first column from your data source. You can change the from Sum to Average, Min, Max, or Count. This does not apply to SQL Server Analysis Services Note:
To remove the filter, reset the operations in the leftmost column of the Show data where list to (Select Operation). Note: Customize the data in PivotDiagram nodes When you expand a PivotDiagram node, a default set of data is displayed in each node. You can change which numeric data is displayed, the name of that data, and how numeric data is summarized. Show or hide specific data When you show or hide the numeric data (usually a column in your data source), the change is applied to all of the nodes in the selected PivotDiagram. Try it! Select any node of the PivotDiagram. In the PivotDiagram window, under Add Total, select or clear the check boxes for the data that you want to show or hide. In the PivotDiagram window, under Add Total, right-click Sales and choose Avg. Average sales is now displayed on the pivot nodes. Note that this column can also be configured. Change the configuration so that only sales greater than $600 are displayed. Change how numeric data is summarized The default data shown in a PivotDiagram node is the sum of the first column from your data source. You can change the from Sum to Average, Min, Max, or Count. Note: This does not apply to SQL Server Analysis Services
Visio%202010%20Developer%20Training%2002%20-%20Solutions%20and%20Publishing.docx