Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

ResolvedVersion 2003

Fri 13 Feb 2009, 15:43 Delegate Blair said...

Blair has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Pivot tables

After grouping data in a pivot table (eg by month), are you able to create sub total rows to show yearly totals, as well as seeing the grand total?

Mon 16 Feb 2009, 15:13 Trainer Amanda said...

RE: pivot tables

Hello Blair

Thank you for your question and welcome to the forum.

Please refer to the following link regarding creating running totals - I hope you find this useful:

http://www.contextures.com/xlPivot14.html

Kind regards
Amanda

Mon 23 Feb 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips

Pivot tables

Pivot tables

RE: pivot tables

Excel articles

Excel tip:

Counting Blanks