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

[#1]

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.

[llauses243]

Hi,

This is my offer, pls to see image attached

Good luck, Luis

[rohit214]

hi  

try this

add one more expression in your 1st pivot table sum(Material_Estructuras)+sum(total Material_Rutas)

may it helps you

thanks

rohit

[#4]

Thanks Guys I´ll follow your instructions!!