Hi Folks,
I need your help. Here is the scenario - I have created a dashboard for official purpose and it's graphs and charts are being created with the help of pivot tables which are linked to master data sheet. I wish to make it 100% interactive one. Now challenge here is I do want to give an option in the dashboard main page with the help of slicer or timeline in such a way that it should pick up all existing employees details for a particular period of time (could be back dated) or until a time period since the beginning. My guess is we would need to create a formula in excel master data sheet and it needs to be linked to pivot tables. Time period can be monthly and quarterly for 5 years data. I am a rookie and looking forward for help from experts to create the formula.
Thanks in advance!
Need
I need your help. Here is the scenario - I have created a dashboard for official purpose and it's graphs and charts are being created with the help of pivot tables which are linked to master data sheet. I wish to make it 100% interactive one. Now challenge here is I do want to give an option in the dashboard main page with the help of slicer or timeline in such a way that it should pick up all existing employees details for a particular period of time (could be back dated) or until a time period since the beginning. My guess is we would need to create a formula in excel master data sheet and it needs to be linked to pivot tables. Time period can be monthly and quarterly for 5 years data. I am a rookie and looking forward for help from experts to create the formula.
Thanks in advance!
![75360 75360](https://chandoo.org/forum/data/attachments/75/75452-e065df104a0e45d6f3767ee19e2a8378.jpg)