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?
Solved! Go to 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.