This content has been marked as final.
Show 1 reply
-
1. Re: Multiple filter conditions on the same dimension?
Tracy RodgersFeb 23, 2012 12:28 PM (in response to yao.tang)
1 of 1 people found this helpfulHi Yao,
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:
count([Product])=countd([Product])
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!
-Tracy