Learn how to create nested subtotals
Here are the steps to follow in this video lesson:
- Sort your data before creating your 1st Subtotal (Data, Subtotals, etc.)
- Create your 2nd (“nested”) Subtotal – remember to choose a different field for “At each change in:”
- Uncheck the “Replace current subtotals” box.
- Before you can “copy and paste” your 2nd level subtotal outlined view click – Edit, Go to, Special, Visible cells only” – or use the Keyboard Shortcut Alr+;
December 30th, 2009 at 11:37 AM
[...] Learn how to create Nested Subtotals [...]
December 30th, 2009 at 1:41 PM
[...] Learn how to create Nested Subtotals [...]
January 5th, 2011 at 3:14 PM
Awesome tips, thanks!