Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - How to add data fields to Excel-type visual reports?
How to add data fields to Excel-type visual reports?
1. Click any cell in the PivotTable report, and then click the Analysis tab-click Fields, Items and Sets-select a field.

2. In the pop-up calculation field dialog box, enter A/C as the name, that is, the total value of column A divided by the total value of column B, and enter the formula: = a/c..

Click OK. You can also use an insert field when entering a formula, such as the total value a. You can select a below, and then click Insert Field.

Just click OK.

3. The effect is shown in the following figure: