Multiple data from the same source

You are not clear
Maybe if you shared the file we would understand better and maybe help

So, if Nick receives another evaluation, it should enter automatically in the Pivot. However, it is not working if there is more than 2.

Is there a way to have more evaluations submitted under the same name?

I still dont understand your question.
Try creating an intermediate colum in your data (e.g. Evaluation number) and place it in the row section of your pivot table. Without that Pivot table will aggregate for each name.

I m sorry but I m trying to explain . The example is that if you Nick (in the file) receives the 3rd evaluation as Fail, it will go and sum-up to the Fail column, instead of adding a 3rd row for him.
That way, I cannot know how many Fails there are, nor the score for each one of them. I want every result separately in the pivot table.

Hey tgatheru, I have found the solution but I think it will be more complicated to explain.
Anyway, thank you for your interest.