2 Replies Latest reply: Jun 3, 2015 4:32 AM by Corinna Mehl RSS

    if statement in expression when using dynamic dimension

      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!