Pivot Table - Calculated Item question

[scott_86_]

Hi,

Using Microsoft 365.

The snip below is an example from a much larger pivot table I am currently using. I would like to create a new column called 'Outcome' based on:

=IF(AND(Height=2,Rescue=2,PFA=2),2,4)

So, for example, Frank would then be a TRUE with a result of 2. Rick would be a FALSE with a result of 4.

I think I need to use a calculated item for this; however, I'm not 100% sure and have had no luck so far. Could anyone assist in how to specifically go about creating this new column? Thanks.

 

[bobaol]

Hello scott_86_, yes, you are correct. Assume Names is Column A, and Outcome is column F. Frank is in cell A5. I would do it this way... in G5, =if(b5=2,1,0) in H5, =if(c5=2,1,0) in I5, =if(d5=2,1,0) in J5, =(g5+h5+i5) in K5, =if(j5=3,true,0) back to F5, in F5, =if(k5=true,2,J5) hope this helps. cheers!