http://m.getsatisfaction.com/topics/7763115 Report > Advanced filtering for exclusions 2018-07-25T04:22:34Z 2018-07-12T13:13:09Z 7763115 http://m.getsatisfaction.com/topics/7763115 7763115 Report > Advanced filtering for exclusions 2018-07-25T04:22:34Z 2018-07-12T13:13:09Z Matthew Lind http://m.getsatisfaction.com/people/7547391 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10542606/photo_medium.jpg matthew_lind Within Report Builder, has anyone solved for a filtering scenario that involves excluding rows based on a combination of fields?<br /><br />For example, if I have a dataset in which all of my users are assigned a letter (A, B, C, D, etc.) and also a number (1, 2, 3, etc.)<br /><br />I would like to see all of the users who have an A, and all of the users who have a 1, but I want to exclude from view any of the users who have the combination of A and 1. question complete 8 4 2 comment http://m.getsatisfaction.com/topics/7763115/replies/19634966 http://m.getsatisfaction.com/topics/7763115 19634966 Marcelo responded to "Report > Advanced filtering for exclusions" 2018-07-12T13:56:39Z 2018-07-12T13:56:39Z Marcelo http://m.getsatisfaction.com/people/9155904 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11109402/ScreenShot2017-07-19at10.02.30AM_medium.png marcelo_buil What if in the filter you set it to Letter != A Number !=1 and then on the filter setting you set it to . (A and B)? 2 http://m.getsatisfaction.com/topics/7763115/replies/19634969 http://m.getsatisfaction.com/topics/7763115 19634969 Andy Roy responded to "Report > Advanced filtering for exclusions" 2018-07-12T13:57:21Z 2018-07-12T13:57:21Z Andy Roy http://m.getsatisfaction.com/people/8756453 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11229950/archer-628-large_medium.jpg andy_roy_5pgm4snxmsllt In your example, it sounds like there's a "Letter" field that might = A, and a "Number" field that might = 1.&nbsp; If so, then you'd theoretically just use something like<br /><br />Filter A:&nbsp; Letter=A<br />Filter B: Number=1<br />and the expression:<br />&nbsp;<b>(A OR B) NOT (A AND B)</b>&nbsp;<br /><br />Too bad we can't use NOT as an operator.&nbsp; I just voted up this related Idea.&nbsp; Finding another way still sounds like an interesting challenge, but being able to use "NOT" would really tie the room together.&nbsp; ;)<br /><a href="https://community.gainsight.com/gainsight/topics/filtering-in-reports-for-does-not-start-with" rel="nofollow" target="_blank" title="Link https//communitygainsightcom/gainsight/topics/filtering-in-reports-for-does-not-start-with">https://community.gainsight.com/gainsight/topics/filtering-in-reports-for-does-not-start-with</a> 2 http://m.getsatisfaction.com/topics/7763115/replies/19635014 http://m.getsatisfaction.com/topics/7763115/replies/19634969 19635014 Matthew Lind responded to "Report > Advanced filtering for exclusions" 2018-07-12T14:23:19Z 2018-07-12T14:23:19Z Matthew Lind http://m.getsatisfaction.com/people/7547391 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10542606/photo_medium.jpg matthew_lind I was guarding against floating a solution to my own question, because I wanted to get some good opinions or creative solutions. You're right, Andy, in that I would use a NOT operator tomorrow if it was available. 1 http://m.getsatisfaction.com/topics/7763115/replies/19635016 http://m.getsatisfaction.com/topics/7763115/replies/19634969 19635016 Andy Roy responded to "Report > Advanced filtering for exclusions" 2018-07-12T14:24:27Z 2018-07-12T14:24:27Z Andy Roy http://m.getsatisfaction.com/people/8756453 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11229950/archer-628-large_medium.jpg andy_roy_5pgm4snxmsllt Keep hope alive! :) 1 http://m.getsatisfaction.com/topics/7763115/replies/19635040 http://m.getsatisfaction.com/topics/7763115/replies/19634966 19635040 Matthew Lind responded to "Report > Advanced filtering for exclusions" 2018-07-12T14:33:33Z 2018-07-12T14:33:33Z Matthew Lind http://m.getsatisfaction.com/people/7547391 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10542606/photo_medium.jpg matthew_lind Thanks Marcelo. I've found when I attempt that, I end up excluding all of the A's and then also excluding all of the 1's. 0 http://m.getsatisfaction.com/topics/7763115/replies/19636706 http://m.getsatisfaction.com/topics/7763115/replies/19634966 19636706 Rakesh responded to "Report > Advanced filtering for exclusions" 2018-07-13T08:33:18Z 2018-07-13T08:33:18Z Rakesh http://m.getsatisfaction.com/people/9591662 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11294298/CasualSmall_medium.png rakesh_reddy_kondam Hi Matthew,<br />Can you try Marcelo's suggestion with (A <b>or</b> B)?&nbsp;<br />Theoretically, (A ∩ B)' = A' U B'.<br /><br />For your exact question, filters needed would be<br />Filter A: Letter A<br />Filter B: Number 1<br />Filter C: Not Letter A (!= A)<br />Filter D: Not Number 1 (!= 1)<br />In advanced logic: (A or B) and (C or D) 1 http://m.getsatisfaction.com/topics/7763115/replies/19636900 http://m.getsatisfaction.com/topics/7763115/replies/19634966 19636900 Matthew Lind responded to "Report > Advanced filtering for exclusions" 2018-07-13T12:41:31Z 2018-07-13T12:41:31Z Matthew Lind http://m.getsatisfaction.com/people/7547391 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10542606/photo_medium.jpg matthew_lind Rakesh, I attempted your suggestion on the dataset and did not get the results I was hoping for. Records I wanted to exclude because they met BOTH of my criteria still appear in the results.<br /><br />Given that in my use case, I have 4 pairs of values to exclude (I need to exclude A1, A2, A3 and B1), even if this did work, I would end up with at least 16 filters and an advanced logic string that makes me shudder.<br /><br />The ability to generate a Calculated Field within a Report (in this case, to CONCAT) would give me a more straightforward solution and put Reports at more parity with Bionic Rules. 1 http://m.getsatisfaction.com/topics/7763115/replies/19658523 http://m.getsatisfaction.com/topics/7763115/replies/19634966 19658523 Rakesh responded to "Report > Advanced filtering for exclusions" 2018-07-25T04:22:34Z 2018-07-25T04:22:34Z Rakesh http://m.getsatisfaction.com/people/9591662 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11294298/CasualSmall_medium.png rakesh_reddy_kondam Hi Matthew,<br />Concat should be one of the functions in the <a href="https://community.gainsight.com/gainsight/topics/formulas-in-reports-2-0?topic-reply-list[settings][filter_by]=all&amp;topic-reply-list[settings][reply_id]=19548858#reply_19548858" rel="nofollow" title="Link: https://community.gainsight.com/gainsight/topics/formulas-in-reports-2-0?topic-reply-list[settings][filter_by]=all&amp;topic-reply-list[settings][reply_id]=19548858#reply_19548858">formula fields</a>&nbsp;capability we have on our roadmap!&nbsp; 0