-
1. Re: Data Prep and Filtering
Sherzodbek Ibragimov Oct 25, 2016 8:39 AM (in response to Lauren Blumberger)Lauren,
Have you tried to use set function to handle it. I have tried to get your result as seen below:
I have play little bit to get the exact result you want but it could guide you to the result you want. If I have time, I will try to play with it again. Also, I have attached workbook for your reference.
-
set sample.twbx 16.8 KB
-
-
2. Re: Data Prep and Filtering
Lauren Blumberger Oct 25, 2016 9:26 AM (in response to Sherzodbek Ibragimov)Hi Sherzodbek,
Thanks for the response! I haven't used sets before but it seems like a logical approach. I'm taking a look at the workbook now and seeing how I can manipulate it. Sheet one is filtering the way I would like, but sheet 2 contains employee A who also is also at store 1 so it shouldn't be in the list. Do you know what would fix this?
-
3. Re: Data Prep and Filtering
Sherzodbek Ibragimov Oct 25, 2016 11:01 AM (in response to Lauren Blumberger)Lauren,
I didn't have a chance to fully figure out the second sheet, but definitely try to play with set options by right clicking and editing options. You may want to create another set that will include a employee in set and exclude it from set i have created for large store or something like this logice, so you would have two sets for sheet two. If not, i will try to play with it by the end of day. Thanks again
-
4. Re: Data Prep and Filtering
Sherzodbek Ibragimov Nov 10, 2016 7:41 PM (in response to Lauren Blumberger)Lauren,
It has been almost two weeks since your question was answered, I just wanted to check back with you if solution provided here answered your question or not. If yes, please mark as Correct Answer or as Assumed Answer if you find your solution yourself so that it is cleared from question board that needs to be answered as well as other users in future can benefit from it. If not, please feel free to ask for help. I appreciate your help on that. Thank you.
Sherzod