Forum Discussion
Filter Calculated Column Dynamically - Show Results for Former Employees based on Date Range
Hi, I wonder if someone can help me with a particular conundrum. I have a report looking at employee results this year. Since the start of the year some employees have left but there results ...
Hi Ashish_Mathur,
I can't attach a link to the file I'm afraid, there's sensetive information on there. So I've mocked up a really simple example of what I'm trying to achieve. Click here to access it.
Imagine in Week 1 I have 8 active employees. In that week only 7 of them record hours worked. I would want my chart to show all 8 employees even with the employee who didn't record time. In Week 2, 2 of the employees are now longer active, so when this week is selected on the report they shouldn't appear at all.
I want a date slicer to allow me to swtich between these.
Does that help?
Hi,
That link is not valid.