1 of 1 people found this helpful
This should be possible. First, the place Product Brand on the filter, then filter out Brand2. Next, place a date field on the filter so that it will only show the customers who bought in the last 5 years (filter out anything before that). The next part is the tricky part. Create a calculated field that is similar to the following:
Place this on the view. If it is true, then, the customer has not bought the same product in the last 5 years. Then, from there you should be able to filter out the last 6 months as well.
Hope this helps!