00:00all right you pivot table lovers pop quiz for you how do you remove grand total from your pivot
00:05table i'm talking about row 23 and or column h well here's how you do it first you're going to
00:12place your cursor anywhere on your pivot table select design from the ribbon and then under
00:17layout there's this pull down to a grand total now you represent it with four different options
00:22for example if you want to keep only row 23 and height column h you're going to be selecting
00:28on for columns only which is columns total you select this guy here you can see column h is gone
00:34now if you want to restore column h and height row 23 go back to the pull down here and
00:39select on for
00:40row only which is totaling up the grand total for each row now if you want to hide both column
00:47and
00:47row you basically say off for row and column and the grand totals are completely gone now if you want
00:54to
00:54restore both row and column basically go back again to your layout grand totals and on for row and columns
01:00you
01:01you
01:02you
01:02you
