6 Replies Latest reply: Feb 28, 2013 3:03 PM by Nazmi Doganc RSS

    Filtering with set analysis

    Nazmi Doganc

      I have a problem with the usage of set analysis. I have the following Pivot Table:

      Picture.jpg

       

      The Result 2 Field, calculates the sum of the field "z_dauer". Here the formula "sum(z_dauer)". It is calculating the total sum for the field "mitarbeiter_id" in this case. For instance the "mitarbeiter_id" 296 has total z_dauer of 4537,75, 317 has 3958,5 and so on. I want to filter this depending on the field "projektnummer".

       

      In the Result 1 column, I used :

       

      sum({$<z_projektnummer =  {M112082} >} z_dauer)

       

      This way, Result 1 filters the z_dauer with the value "M112082".

       

      In the Result 3 column, I used:

       

      sum({$<z_projektnummer =  {$(=projektnummer)} >} z_dauer)

       

      But unfortunately this does not work.

       

      How can I tell my code to filter depending on Column projektnummer in this case?

       

      Thanks for any help.