Show Or Hide Subtotals And Totals In. However if your Matrix rows contain GroupsHirearchies then you will come up with all the line item in your table appearing in each group. The only subtotal you can use with selection-based sets is Total.
The only subtotal you can use with selection-based sets is Total. I would like to deactivate the drill down on the subtotal rows on my PowerPivot report. To hide grand totals uncheck the box as required.
To display grand totals by default select either show grand totals for columns or show grand totals for rows or both.
To display the data summary ie. Click anywhere in the pivot table. Click the name of a report to execute it. Hiding only the column subtotals.
