Installing the New GrandTotal: A Guide for Calculating Survey Impact

When analyzing customer satisfaction surveys, it's essential to understand how individual responses contribute to the overall total score. In this article, we'll explore how to create a calculation field in a pivot table to measure the impact of each survey on the grand total.

Calculating the Impact

To calculate the impact, you need to create a formula that multiplies the percentage of surveys by the corresponding score. In our example, let's assume we have a table with filtered data showing only the necessary information. We'll use this table as the basis for our calculation.

First, add a new column to your pivot table and name it 'Impact on Total Score.' Then, enter the following formula:

`=Amount of Surveys / Grand Total * C-Sat Score`

This formula calculates the percentage of surveys for each individual by dividing their survey count by the grand total. It then multiplies this percentage by their corresponding C-Sat score to determine the impact on the overall average.

Visualizing the Impact

To better understand the impact, you can use a pivot table with row labels showing the names, and two value columns: one for the sum of amount of surveys and another for the average C-Sat score. This will allow you to visualize how each individual's responses contribute to the grand total.

Subtotaling in Excel

When working with large datasets, subtotaling is a powerful feature that enables you to quickly add totals to groups within a column. In addition to providing subtotals, Excel also allows you to display grand totals at the bottom of the table.

To use subtotaling, follow these steps:

1. Select the range of cells containing your data.

2. Go to the 'Data' tab in the ribbon.

3. Click on the 'Subtotal' button in the 'Outline' group.

4. Choose a location for your subtotal (e.g., above or below each group).

5. Select the column(s) you want to subtotal.

Calculating the impact of individual surveys on the grand total score can provide valuable insights into customer satisfaction patterns. By using pivot tables and subtotaling, you can easily visualize and analyze this data in Excel. Remember to adjust your formula according to your specific needs and data structure. With these tips, you'll be well on your way to making informed decisions based on your survey results.

Instal the new GrandTotal