Filter pane selection

[govindvasu]

I have a filter pane with the years(2021,2022,2023) and my data is as below

emp_id   count    Date      Name

1                     0           08/07/2022   chris

2                     1           08/09/2021    John

3                     1          08/07/2020     kathy

1                     1          08/07/2021     chris

1                     1          08/07/2020     chris

1                     1          09/07/2020     chris

When I select the Year 2020 in filter pane then in the next sheet it has to show the unique emp_ids in that specific year   as below

emp_id   Name

1                 Chris

3                  kathy

how can I build this?

Note: I don't have access to vzlib. I would like to build this using without vizlib

[MatheusC]

Hi, @govindvasu 

Basically it would be creating a key with year in your fact table, which has the measure count.
If it is correctly in date, you can only from your date do year(Date) as Year and link with the filter table.

I hope it helps

[govindvasu]

Let me rewrite my question. In filter pane section year has to work in two ways. If the year is selected in the current sheet it has to show the information specific to the selection year and in the next sheet it has to show you the unique employees in that specific year.