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: For instance, the image below displays the Pivot dashboard item with the disabled row totals:               Moreover, you can control the visibility of totals for individual dimensions/measures by using the data […]

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:

In the tab “Data” it is possible to create a quick filter for the whole pivot. It could be done in two ways: Way 1. Click “Edit Filter” button in “Data” tab in dashboard design window. Way 2. Open context menu (click the right mouse button) at any place of a pivot. Only those hierarchies, […]

In order to change the format of a calculating value, you need to open context menu: A numeric-format form will open: The form contains following fields: Format type – format type may be: Unit – Date and currency format type may have the following presentation: Precision – number of symbols after comma; Currency – currency […]

Upon opening value context menu, it is possible to create a formatting rule (highlighting):