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

pivot tables

ResolvedVersion 2007

Victoria has attended:
Excel Advanced course

Pivot tables

how do you do a formular inside a pivot table

RE: pivot tables

Hi Victoria,

Thank you for your question.

You can create formulas by either inserting a calculated field or calculated item.

Please find the following links that will help guide you through the process.

http://www.contextures.com/excel-pivot-table-calculated-field.html

http://www.databison.com/index.php/calculated-field-and-calculated-items-in-a-pivot-table/

I hope this helps.

Regards

Simon

Wed 27 Oct 2010: Automatically marked as resolved.

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.31 secs.