Jtucker10278
Board Regular
- Joined
- May 14, 2017
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
Having problems wrapping my head around this one.
so my plan is to have a table that will have
DATE EMPLOYEE PROJECT# QTY
for any day i would have 12 or so employees building panels, some building panels for 2 or 3 projects in a day.
what I need to be able to do is total the data by week. and a week is defined as Saturday through Friday.
also, the goal I'm working towards is a dashboard, not a Pivot table.
any thoughts would be appreciated!
so my plan is to have a table that will have
DATE EMPLOYEE PROJECT# QTY
for any day i would have 12 or so employees building panels, some building panels for 2 or 3 projects in a day.
what I need to be able to do is total the data by week. and a week is defined as Saturday through Friday.
also, the goal I'm working towards is a dashboard, not a Pivot table.
any thoughts would be appreciated!