Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Pivot Tables

ResolvedVersion 2007

Mon 15 Jun 2009, 17:15 Delegate Tatiana said...

Tatiana has attended:
Excel Advanced course

Pivot Tables

Hi,

I need to import a calculation column into a pivot table but I'm not sure which option to use in this column, i.e. sum, count, var, etc... The calculation is a simple (A+B)/C sum. Please can you advise?

Thanks,

Tatiana.

Mon 15 Jun 2009, 17:35 Trainer Amanda said...

RE: Pivot Tables

Hello Tatiana

Thank you for your question.

You can only create a calculated field in a column if you are using names of fields to do the calculation (see link below); otherwise try adding an extra column into your data range for the pivot table and creating the calculation there before creating the table.

http://www.ozgrid.com/Excel/pivot-calculated-fields.htm

Kind regards
Amanda

Mon 22 Jun 2009: Automatically marked as resolved.

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Viewing two Excel 2010 Workbooks at the same time