Need your help to create a formula to capture active employees for a particular time period

%3CLINGO-SUB%20id%3D%22lingo-sub-2558089%22%20slang%3D%22en-US%22%3ENeed%20your%20help%20to%20create%20a%20formula%20to%20capture%20active%20employees%20for%20a%20particular%20time%20period%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2558089%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Folks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20your%20help.%20Here%20is%20the%20scenario%20-%20I%20have%20created%20a%20dashboard%20for%20official%20purpose%20and%20it's%20%3CSTRONG%3Egraphs%20and%20charts%20are%20being%20created%20with%20the%20help%20of%20pivot%20tables%20which%20are%20linked%20to%20master%20data%20sheet%3C%2FSTRONG%3E.%20I%20wish%20to%20make%20it%20100%25%20interactive%20one.%20Now%20challenge%20here%20is%20I%20do%20want%20to%20%3CSTRONG%3Egive%20an%20option%20in%20the%20dashboard%20main%20page%3C%2FSTRONG%3E%20with%20the%20help%20of%20%3CSTRONG%3Eslicer%20or%20timeline%3C%2FSTRONG%3E%20in%20such%20a%20way%20that%3CSTRONG%3E%20it%20should%20pick%20up%20all%20existing%20employees%20details%20for%20a%20particular%20period%20of%20time%20(could%20be%20back%20dated)%20or%20until%20a%20time%20period%20since%20the%20beginning.%3C%2FSTRONG%3E%26nbsp%3BMy%20guess%20is%20we%20would%20need%20to%20create%20a%20formula%20in%20excel%20master%20data%20sheet%20and%20it%20needs%20to%20be%20linked%20to%20pivot%20tables.%20Time%20period%20can%20be%20monthly%20and%20quarterly%20for%205%20years%20data.%20I%20am%20a%20rookie%20and%20looking%20forward%20for%20help%20from%20experts%20to%20create%20the%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20610px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296554i5067F318883AC0ED%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2558089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2560121%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20your%20help%20to%20create%20a%20formula%20to%20capture%20active%20employees%20for%20a%20particular%20time%20period%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2560121%22%20slang%3D%22en-US%22%3EYou've%20had%20a%20fair%20number%20(42)%20of%20views%2C%20but%20zero%20replies.%20I%20suspect%20it's%20because%20you've%20given%20us%20too%20little%20to%20work%20with.%20Is%20it%20possible%20for%20you%20to%20attach%20a%20copy%20of%20the%20workbook%20that%20you%20are%20working%20with%2C%20just%20replacing%20any%20names%20of%20real%20people%20(or%20other%20identifiers)%20with%20the%20names%20of%20fictitious%20characters%3F%3CBR%20%2F%3E%3CBR%20%2F%3EPart%20of%20the%20reason%20for%20that%20request%20is%20that%20seeing%20how%20your%20basic%20data%20is%20organized%20can%20be%20very%20helpful%2C%20but%20also%20just%20the%20basic%20reason%20that%20without%20working%20with%20some%20resemblance%20of%20what%20you're%20actually%20working%20with%2C%20we%20would%20have%20to%20guess%20or%20create%20our%20own.%3C%2FLINGO-BODY%3E
Visitor

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!Capture.PNG

1 Reply
You've had a fair number (42) of views, but zero replies. I suspect it's because you've given us too little to work with. Is it possible for you to attach a copy of the workbook that you are working with, just replacing any names of real people (or other identifiers) with the names of fictitious characters?

Part of the reason for that request is that seeing how your basic data is organized can be very helpful, but also just the basic reason that without working with some resemblance of what you're actually working with, we would have to guess or create our own.