How can I display the list of formula for making PivotTable report?

How can I display the list of formula for making PivotTable report?

For you to display the list of formulas that are used in the PivotTable report you have to:

• Click the Pivot Table report.
• Look for “Tools” tab, and click on it, there will be a drop-down
• Look for “formulas”, click on it.
• Click “list formulas” 

If this doesn’t work, then you have to make your own formula first, here’s how:

There are two ways to make a formula:

• Whether you want a calculated field (when your going to use a data from another field in your formula) or a calculated item within the field (when you want your formula to use data from one or more specific items, ex. In the field “Week”, the items could be “Sunday”, “Monday”, and so on.)

In a calculated field:

1. Click the Pivot Table report.
2. On the Upper Left part of the screen, on the Option tab, look for Tools group an hover your cursor on it, there will be a drop-down and click Formulas, and then click Calculated Field.
3. Type the name for the field in the Name Box.
4. In the Formula box, enter the formula for the field.

To use the data from another field in the formula, click the field in the Fields box, and then click Insert Field. For example, to calculate a 15% commission on each value in the Sales field, you could enter = Sales * 15%.

5. Click Add.

For calculated item:

1. You have to click Ungroup, in the Group, on the Option tab, if the items in the field are grouped.
2. Click the field where you want to add the calculated item.
3. On the Options tab, in the Tools group, click Formulas, and then click Calculated Item.
4. Type a name for the calculated item in the Name box
5. And, in the Formula box, enter the formula for the item.

To use the data from an item in the formula, click the item in the Items list, and then click Insert Item (the item must be from the same field as the calculated item).

6. Click Add.
7. If you ungrouped items in step 1, regroup them if you want.