Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

To create a calculated field on Excel 2000 and earlier, right-click in the data area of the pivot table and choose the menu command Formulas->Calculated Field.

On 2002 and 2003, right-click in the data area of the pivot table and choose Show PivotTable Toolbar and then choose the menu command PivotTable->Formulas->Calc

On 2007 and later, on the Options tab, Tools group, click on Formulas and choose "Calculated Fields".

In the Name text entry field, type a name for the calculated field. In the Formula text entry field, type the formula for the field. To use the data from a field in the formula, click the field in the Fields box, and then click Insert Field. Click Add, and then click OK. See Excel help for more information about how to constuct pivot table formulas and how to reference source data - enter "pivot table formulas" to see the relavent topics.

Notes:

Calculated fields can only be used on non-OLAP source data.

Calculated fields are calculated at the aggregate level, not the item or record level. This means that some formulas may not work as desired such as any formulas with conditional logic.

Kevin