Excel provides several layout and style options to make pivot table more visually appealing.
Layout options control:
Style options are tools that add color and banding:
Use the option in the PivotTable Design Ribbon to set subtotals globally:
You can view subtotals for just one of the fields by right clicking in any cell in a particular column.
This example shows grand totals for columns. (You should turn them off for Financial Summary Reports):
There are three options for Report Layout. But the two most commonly used are:
They are accessed from the Design Tab - which is only available if your cursor sits within a pivot table.
This option keeps fields in separate columns, appropriate for QQube detailed data models.
This option "compacts" multiple fields in the SAME column and is more conducive for the QQube Financial Summary Reports.
We have noted several common options e.g. bold column headers, and banded rows.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/105/design-options
Your session has expired. You are being logged out.