This content has been marked as final. Show 3 replies
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.