Multi Field Filter Is not empty Test

[relderton]

I have 10 license groups that I have created as fields using a crosstab tool. I need to filter to return users that have more than 1 license. 

For example:

Person 1 could have license 1 and 7 

Person 2 could have license 4 and 5 

Is there a way to test all 10 license groups at the same time to return users that have more than 1 license?

[apathetichell · Accepted solution]

why not add a summarize/group by person/count prior to the crosstab? then join that to the pre-crosstab data so you have the count - THEN crosstab.