SUM Daily product qty by pivot subquery


I would like to sum daily product qty by pivot sub. However I need to type ever day in the value list.(refer to the picture). Are there any way to make daily list follow the employee clockindate?


dailyproduct.baq (53.4 KB)

Does it have to be by specific dates? I’ve used a Pivot for pay hours for the last 14 days where I used a DATEDIFF function in my subquery to return the day number, then add those value to your Pivot function.

datediff(day, “fieldwithdate”, today())