Pivot Table Not Populating Correctly

[Kumara_faith]

Hi,

I need help on my pivot table.

On the sheet named "table", the Feb Q (cell B8)data for staff M1 should be 81.25% but the pivot table is populating as 100%. In fact, it is populating 100% for all staff and I am not sure why.

Appreciate help.

[darkyam]

Right click on Feb Q, Summarize Data By, then Sum. Right now, it is set to Count instead.

[Kumara_faith]

Thank you Darkyam. That worked. I am quite new on Pivot chart and tables. Appreciate your time and patience.