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

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

Prefilter.yxmd