3 Replies Latest reply: Dec 15, 2011 6:49 PM by javierortiz RSS

    How can I sum the same selection field that is in other field?

      Hi All, If I have one product in 2 diferent fields in 2 diferent tables, how can In sum of the value of the second table if is not selected?, my table brings the sum selected, but I need to add the value of the same selection that is in other table in other field.

       

      in other words:

       

      If I select the product "TUET10125" in field "Material_Estructuras"

       

      I have a pivote table that gives me the sum value of the field "Material_Estructuras" ,

       

       

      but If I select the product "TUET10125" in field "Material_Rutas"

       

      I have another pivote table that gives me the sum value of the field "Material_Rutas" ,

       

       

      What I need is to get the first pivote table with the sum of the selection from both tables even if is not selected the product in field "Material_Rutas".

       

       

       

      does any body have any idea?

       

      I attached the app for a better understand.