Forum Discussion

markholland's avatar
markholland
Helper I
8 years ago

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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share the link from where i can download your file.  Also, it will be great if you can show the expected result in a simple Table for a few items chosen in the slicer.

markholland's avatar
markholland
Helper I
8 years ago

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?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    That link is not valid.