Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
This is my offer, pls to see image attached
Good luck, Luis
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
Thanks Guys I´ll follow your instructions!!