Calculating Impact on Grand Total Score

In this article, we will explore how to create a calculated field in a pivot table that calculates the impact of a person's score on the grand total score as a percentage.

To achieve this, we first need to set up our data correctly. We have a table with three columns: names, amount of surveys, and C-Sat score. The pivot table is filtered to only show the relevant data.

The first step is to create a calculated field that calculates the impact on the grand total score as a percentage. To do this, we can use the following formula:

`Impact = ('Amount of Surveys' / Grand Total) * 'C-Sat Score'`

This formula divides the amount of surveys for each person by the grand total number of surveys, and then multiplies it by their C-Sat score.

Next, we need to add a column to our pivot table that displays this impact as a percentage. To do this, we can use the following calculated field:

`Impact % = Impact / Grand Total * 100`

This formula calculates the impact as a percentage of the grand total score.

Here is an example of what the final result might look like:

| --- | --- | --- | --- | --- |

| John | 10 | 20 | 2.00 | 12.50% |

| Jane | 20 | 15 | 3.75 | 18.75% |

| Joe | 5 | 25 | 1.25 | 6.25% |

In this example, John's impact on the grand total score is 2.00, which is 12.50% of the grand total score.

By using calculated fields in our pivot table, we can easily calculate the impact of each person's score on the grand total score and display it as a percentage.

'instal the new GrandTotal'

Instal the new GrandTotal