I need your help once again. I am creating a dashboard and cannot get a few things to work:
1) I use two tabs to load hourly actual data and budget. Name fields are different in both, but to my understanding names should link based o the employee number, since this is unique. When I choose one name filed over another my fields in the table below populate only for values from that specific tab. Shouldn't it be interactive?
2) When in the right corner "results of" I have a specific date based on the actual hours report, I need to be able to show toat hours budgeted to that date as well (sum of prior dates to that one)
2) For example I select Employee 1, so the actual hours are shown as of 10/9/2016, meaning, no hours were logged after that day. Therefore, total hour budgeted to date should be the sum of all hours from 11/17/2014 through 10/03/2016 (budget is weekly, so the week of 10/03/2016 would include 10/9/2016) . Which would be 40 hours