For such dashboard element as pivot, chart, scatter chart, diagram there is a possibility to transpose lines and columns for a grid, parameters and sets of diagrams, axes “X” and “Y” of a chart:

Pivot is a multidimensional array of data: Let us take a “Pivot” that shows volume of sales and profit by product category in each country as an example. For this we choose “Pivot” in the toolbar, in the value field we will have “Reseller Sales Amount” and “Reseller Gross Profit” measures, on the rows of […]

By clicking  and  buttons, you can expand/minimize data to needed extent.

The Pivot layout can be: Compact Tabular Use the “Layout” button in the “Design” ribbon tab to change the Pivot layout:

You can control the visibility of totals and grand totals for the entire “Pivot” dashboard item:

“Initial State” of a pivot may be the following: Expand Column Groups Expand Row Groups By ticking this functionality box, we will always see an expanded level:

In the pivot table, you can enable or disable grand totals:

For the pivot of the tabular type, you can enable and disable totals for the highest level: Moreover, you can control the visibility of totals for individual dimensions/measures by using the data item’s context menu (“Show Totals” and “Show Grand Totals” options):

If necessary, you can change the Pivot dashboard item’s totals/grand totals position:

The “Pivot” dashboard item allows you to control the position of headers used to arrange summary values corresponding to different measures: