Manipulation – Subtotal

Objective/usefulness: To provide summation of Metrics in the Report at different aggregation levels. Proceed as follows:

  1. Open the Data menu | Subtotals.
  1. Select Total | then open the Display Options tab, shown as follows:

Display Options tab
  1. Select the Top of each level in the positions by row | OK. You should see subtotals across all rows. You can control which subtotals to show through the Advanced button within the subtotals window.
  2. Press F11 to keep only the grand total.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.141.27.74