Hello, I am looking for help creating some formulas in zoho analytics, I have a query table that takes data from multiple modules to put everything into one data source for easy job costing etc... I have employees time punches in here and what project they are punched onto and i am trying to differientiate when they are on a project on regular time and when they are on it in over time. 

In the pivot table i am trying to build, i have the columns laid out as such: Employee, Date (Full Date), Date (Week & Year), Ticket Referenced, Job Number, S.NO, Total billable hours. 

I have figured out how to setup a running total in the data set I clicked sum, running total and have the running total based off the S.NO. this allows me to see the running total for each line of each ticket. which i would be able to create a formula to calculate overtime after 8 hours based on this, but we also have weekly overtime laws so anywork after 44 hours in a week is overtime as well as anything over 8 hours in a day, i thought I would be able to do a running total based off the Date (week& Year) but it doesn't seem to function like that. I am looking for any insite or ideas on how one might do this.