This content has been marked as final.
Show 3 replies
-
1. Re: Como somar varias variáveis
Jim DehnerMar 14, 2018 6:45 AM (in response to Heloisa Moraes)
I would like to see your data but my guess is that it should be pivoted
Please attach a TWBX workbook
see the link Pivot Data from Columns to Rows
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
2. Re: Como somar varias variáveis
Sasha Hanna Mar 14, 2018 7:02 AM (in response to Heloisa Moraes)1 of 1 people found this helpfulHola Heloisa,
Para que la calculacion sea mas simple hay que restructurar los datos, girandolos en su eje.
1. Seleciona las columnas de interes y click en pivot:
2. Asi todas las cifras estaran en una solo columna llamada "pivot values" y poniendolo en la vista te dara la suma.
Espero que te esto te ayude.
Un gusto,
Sasha
-
3. Re: Como somar varias variáveis
Heloisa Moraes Mar 14, 2018 10:44 AM (in response to Sasha Hanna)Obrigado!!