- Click any cell that contains text or numbers.
- Click the PivotTable button in Excel.
- Depending on the Excel version of Excel you are using, a dialog dialogue window may ask you to confirm which data you want to analyze and where you want to place the pivot table. If you see the Create PivotTable dialogdialogue, click OK to confirm the default values.
- Excel creates a pivot table based on all data in the current worksheet and places the pivot table in a new worksheet. Depending on the Excel version of Excel, your new pivot table may be empty or filled with default parameters.
- Go to the PivotTable builder.
- Select the following variables in the Field name section:
- Drag the campaignName and start variable to the Row Labels area. Put the start variable under the campaignName variable.
- Drag the formatName variable to the Column Labels area.
- Drag the clicks and impressions variable to the Values area.
Add new variables or drag variables from area to area to get acquainted with the intricacies of pivot tables' intricacies. The content of the pivot table will change according to the adjustments in the PivotTable Builder.
- Add a calculated field to the pivot table. Go to the Insert menu and click Calculated Field …. The Insert Calculated Field dialog dialogue window opens.
- Provide a name in the Name field, for example, Click-rate.
- Insert the formula in the Formula field.
- Click the Add button to save the calculated field.
- Click the Ok button.
- To add the newly created calculated field to the pivot table, drag the Click-rate variable to the PivotTable Builder's Values section in the PivotTable Builder.
- Select the values and
- Add a conditional formatting rule (Format > Conditional Formatting …) to highlight high and low values in the pivot table, and/or
- Plot a chart to visualize the comparison.