Pivot fields- subtotal, blank row, fill in blank row names

preview_player
Показать описание
00:00 Row field settings in a Pivot Table
00:12 Change the Pivot Table row name in the column
00:24 Subtotals in Pivot Table- not showing, add, remove, change
00:55 Multiple subtotals in Pivot Tables- sum, count, average by month
01:35 Change the row pivot format- outline or tabular
02:10 Fill in the blank cells in a Pivot Table by copying the cell above
02:43 Insert/ remove blank rows in a Pivot Table
03:04 View/ Don't view Pivot items with no data in them (currently)
03:18 Pivot table print page break

The options available in the 'rows' section of a Pivot Table including controlling how the subtotals appear (sum, count, none, or multiple subtotals) and Pivot tricks like filling in the blanks between the category fields so that you can use the Pivot Table report (often with a copy paste) elsewhere.
Рекомендации по теме