Filter on Dynamic Pivot - Transpose

[ISUGraber]

Hello Everyone,

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.

[danilang · Accepted solution]

Hi @ISUGraber 

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

Edit:  Here's what it looks like

Dan

[RobertOdera · Accepted solution]

Hi There!

Try the attached treatment; hope it helps.

[ISUGraber]

Thank you both for replying!  Both of your solutions were great!

[RobertOdera]

You are most welcome!