Hi Sagiv, you should be able to do this using a parameter. You probably won't be able to do everything you described using just normal filters, since the transaction codes appear to overlap between the categories you've specified.
- Create a string parameter that gives you options from a list. That list should consist of the customer groups. Let's call this parameter [Customer Group].
- Create a calculated field that you'll use as a filter. It'll probably look something like this:
CASE [Customer Group]
WHEN "Premium" THEN [Code] = 101 OR [Code] = 103
WHEN "Private" THEN [Code] = 101 OR [Code] = 206
... (Add your other groups here)
- Add this as a filter and include TRUE.
First of all I'd like to thank you for your answer.
The problem is it tells me that I can't use boolean type in case expression.
Ah, I totally forgot about that, sorry. You can change this to a standard Boolean statement:
([Customer Group] = "Premium" AND ([Code] = 101 OR [Code] = 103))
([Customer Group] = "Private" AND ([Code] = 101 OR [Code] = 206))
... (etc etc)