A query on Splunk

Hello I have to build up a query on Splunk, on wich I am a real newbie.
I am in need of a query which it should be teorically simple but I am not able to implement.
I have a sheet in wich every record contains a name, an event, some points related to the single event and a sum of the points that comes from all the previous events.
E.G.
|Person|Action |Pt |Tot|
|John |"eats a pie" | 1| 1|
|John |"does a jump" | 3| 4|
|John |"goes to bed" | 5| 9|

The query should match that the sum of Pt is equal to the last value of Tot.
As a next step, if the two values does not match, then an alert is raised.
Can we talk about it?
Thank you for your interest.
Paolo