Hello help with sum values in the same column

[aparedes]

Hello everyone!!

I´m new in this tool and I need your help in how to sum values in the same column

Here´s the situation:

I have one table and in one column I have different classifications and another column I have total of amounts.

The column of classification have different classifications but those classifications are repeated in all column and I need sum the ammounts for each classification

can you please help me with

Thanks and regards

[Vvelarde]

@aparedes

Hi, please post sample data.

Your data looks like:

Columna A    Columna B

CLASS1        100

CLASS2         80

CLASS3        70

CLASS2       50

CLASS3       70

And you need in a visualization

CLASS1 100

CLASS2  130

CLASS3  140

TOTAL  370

Is correct?

[aparedes]

Hi, @Vvelarde that is exactly that I need and here some example of my data

thanks and regards

[Vvelarde]

@aparedes

Follow the Image instructions

Sigue las instrucciones de la imagen

[aparedes]

Hello @Vvelarde thanks for the quick answer.

This is for the visualization mode and I got it!! But we can do something in a table level like in a new column or calculation because I need with the new measure sum different classification for example

sum Classification "Fria" and Classification "Subproductos" in a new calculate fiel so I can Graph the new calculate field.

Please let me know if you need further information

Regards.

[Vvelarde · Accepted solution]

@aparedes

Using measures:

VentasdeFria=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="Fria"))

VentasdeSubProductos=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="SubProductos"))

VentaFriaandSubProductos=[VentasdeFria]+[VentasdeSubProductos]

or If you want in 1 measure sum Both:

VentasdeFriaandSubProductos=Calculate(Sum('Tabla'[Ventas]),Filter(Tabla,Tabla[Clasificacion]="Fria" || Tabla[Clasificacion]="SubProductos"))

[aparedes]

hello @Vvelarde thanks for your help now is work properly with that calculation

Now I can sum values in the same column

Thanks for all your support

Regards.-