3 Replies Latest reply on Mar 14, 2018 10:44 AM by Heloisa Moraes

Como somar varias variáveis

Heloisa Moraes Mar 14, 2018 6:40 AM

Como faço para faze ra somatória abaixo de uma maneira mais simplificado Ex.: (SUM([V032]) até SUM([V049])

SUM([V032])+SUM([V033])+SUM([V034])+SUM([V035])+

SUM([V036])+SUM([V037])+SUM([V038])+SUM([V039])+

SUM([V040])+SUM([V041])+SUM([V042])+SUM([V043])+

SUM([V044])+SUM([V045])+SUM([V046])+SUM([V047])+

SUM([V048])+SUM([V049])

1. Re: Como somar varias variáveis

Jim Dehner Mar 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.
Like Show 0 Likes(0)

Actions
2. Re: Como somar varias variáveis

Sasha Hanna Mar 14, 2018 7:02 AM (in response to Heloisa Moraes)

Hola 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
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: Como somar varias variáveis

Heloisa Moraes Mar 14, 2018 10:44 AM (in response to Sasha Hanna)

Obrigado!!
Like Show 0 Likes(0)

Actions

Tableau Community