This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm not entirely sure how to dot his so I thought i'd post it here. I have a workflow that generates a list of users and their timecards and checks to make sure they enter enough hours in the week for their timecard. If they do I place an "X" in the week and name, if not I put the hours they've entered (or 0 if none).
The data spits out looking like this
Name Week 1 Week 2 Week 3 ...
Name 3/2/19 3/9/19 3/16/19 Billy X X 20
Joe 10 X 10
Jane X X X
Is there a way to filter it so Jane falls off the final list? If I do a filter prior to creating the transpose I lose the X's that Billy and Joe have. The week names change, they are whatever week end date is occuring when this runs.
Before your crosstab, put in a filter that returns any record that is not "X". Get the unique users from this list and join it to your pre-transposed data. That will filter out Jane and pass all the other records through