Good afternoon,
I have a pivot table that shows who has had a specific outcome as per the below picture for a check on work that has been completed, but I need to create a New calculated field to show the figure below within my current pivot table. The calculation to achieve this in a formula would be =sum(Outcome 1-Outcome 2-Outcome 3)/Checked)*100) but I am unsure how to write this within the calculated field.
The outcome is recorded within my data that feeds the pivot table in column called "Outcome".
I was thinking something like sum(countif('Outcome'="Outcome 1"-countif('Outcome'="Outcome 2" but Im not sure if this is the correct way to go.
thanks in advance
Gavin
I have a pivot table that shows who has had a specific outcome as per the below picture for a check on work that has been completed, but I need to create a New calculated field to show the figure below within my current pivot table. The calculation to achieve this in a formula would be =sum(Outcome 1-Outcome 2-Outcome 3)/Checked)*100) but I am unsure how to write this within the calculated field.
The outcome is recorded within my data that feeds the pivot table in column called "Outcome".
I was thinking something like sum(countif('Outcome'="Outcome 1"-countif('Outcome'="Outcome 2" but Im not sure if this is the correct way to go.
Checked | Outcome 3 | Outcome 4 | Outcome 1 | Outcome2 | New Calculated Field |
60 | 1 | 23 | 36 | 58.33% | |
209 | 5 | 117 | 86 | 1 | 38.28% |
58 | 4 | 24 | 29 | 1 | 41.38% |
59 | 3 | 33 | 19 | 4 | 20.34% |
386 | 13 | 197 | 170 | 6 |
thanks in advance
Gavin