SUM Daily product qty by pivot subquery

Epicor ERP 10
1

Hello

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?

Thanks

PIVOT%20SUBQUERY%20VALUE%20LIST
PIVOT SUBQUERY VALUE LIST.jpg723×666 152 KB

PIVOT%20SUBQUERY%20VALUE%20LIST2
PIVOT SUBQUERY VALUE LIST2.jpg839×573 155 KB

dailyproduct.baq (53.4 KB)

2

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())