Multiple Pivot Table subtotal types & blank row after the subtotal

preview_player
Показать описание
00:00 Remove data columns from a pivot table
00:30 Multiple subtotals in Pivot Table i.e. the SUM, COUNT, AVERAGE, MAX and MIN subtotals together
00:55 Remove one of the SUBTOTAL types from a Pivot Table
01:10 Make the Pivot Table smaller (use less columns)
01:42 Insert blank line after subtotals in the Pivot Table

Working with the rows in a Pivot Table so that you can include multiple subtotal options instead of the default SUM or COUNT subtotal and how to insert a blank line after the subtotals.
Рекомендации по теме
Комментарии
Автор

what a mess this excel pivot formatting is
Long live Crystal Reports :-)

rascasse