We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
I'm trying to figure out how to create a filter which will exclude rows in my report if values in two separate columns are equal.
For example:
KEY VALA VALB
123 5 6
456 5 5
I want the filter to exclude key 456 from report.
Any help would be greatly appreciated.
Solved! Go to Solution.
hi, @Anonymous
there is a simple way that create a calculate column to judge if two values of the current row are the same
judge = IF(Table1[VALA]=Table1[VALB],"yes","no")
then drag the field into report level filter to filter value is "no"
Best Regards,
Lin
hi, @Anonymous
there is a simple way that create a calculate column to judge if two values of the current row are the same
judge = IF(Table1[VALA]=Table1[VALB],"yes","no")
then drag the field into report level filter to filter value is "no"
Best Regards,
Lin
Thanks! That worked great! I used TRUE and FALSE instead of "yes" and "no"
Eric
Create another column:
FILTER = IF(VALA = VALB,"Yes","No")
Then you can filter according to the value of the new column
User | Count |
---|---|
62 | |
56 | |
50 | |
45 | |
34 |
User | Count |
---|---|
120 | |
81 | |
71 | |
48 | |
47 |