if statement in expression when using dynamic dimension
I have the following problem:
The leading dimension in a pivot table is "Priority" (1,2,3,4). Since the customer has SLAs for 1 + 2 and for 3 + 4 I use a dynamic dimension: =If(Priority=1 or Priority = 2, 'Priority 1 + 2', if(Priority=3 or Priority=4,'Priority 3 + 4', 'No Data'))
Now there should be one column with the respective SLA depending on service class and priority. It should be something like if(priority = 1 and serviceclass=1, '96%', if(priority = 1 and serviceclass = 2, 95%,.....)
The point is that this if-statement won't work with my 'Priority 1 + 2' dimension.