Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RubénHPaz
Contributor III
Contributor III

Combine two pivot tables / Combina dos tablas pivotantes

I have two pivot tables with the same rows... I want to show both in only one pivot table... basically put the results of the blue box in a column on the second table (green box). Can you help me?

Tengo dos tablas con las mismas filas... Quiero mostrar ambas en solo una tabla pivotante... básicamente poner los resultados de la caja azul en una columna en la segunda tabla (caja verde). ¿Puedes ayudarme?

A.png

Labels (4)
12 Replies
RubénHPaz
Contributor III
Contributor III
Author

Mmm... Your table hasn't the total of rows like 

TOTAL US$

TOTAL UNITS

Anil_Babu_Samineni

Are you expecting total as Row for all Condition including with Month? 

We just start up something, You can try your own way like how we given the clue. For now, I can't help as I have my other stuff. I will look this either Wednesday or Saturday.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
RubénHPaz
Contributor III
Contributor III
Author

Actually, I can to solve it.

The sinthetic dimension help me. And the Dimensionality for to choose between kinds of result's formula, instead of pick.

I accept your help like valid. Txs for to show me the way. 

 

A.png