if statement in expression when using dynamic dimension

[#1]

Hi,

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.

Has anyone an idea what might be the solution?

Thank you in advance!

[fvelascog72 · Accepted solution]

Hi,

If you need a dimension with Priority 1+2 and 3+4 create it in script.

[#3]

It's that simple....   thank you!