22 Replies Latest reply: Nov 6, 2017 10:42 AM by Oliver Franz RSS

    Ignore Dimension-Filter for If Statement in Pivot Table

    Oliver Franz

      Hey there,

       

      I have an really frustrating problem and hope you might be able to help me.

       

      The following example does not make much sense, but is a downsized / abstract version of my problem.

       

      Table:

      load * inline

      [Dimension1,Dimension2, Value

      A,XX,1

      B,YY,2

      C,ZZ,3];

       

      Now I create a new sheet with

      • Pivot-Table
        • Row: Dimension1
        • Colum: Dimension2
        • Expression: if(Dimension2 = 'ZZ', 15, Sum({1}Value))
      • Filter
        • Dimension1

       

      This works great if there is no filter set.

      dimensionproblem1.PNG

      But is not working anymore as soon as i use a filter.

      dimensionproblem2.PNG

       

      I want to have that table completely independent from any filters that are used.

       

      Do you have any idea of how to achieve this?

       

      Thanks very much for your help!