Distinctive calculation

[DanCasSan]

Hi community,
I am doing an operation to obtain the summation of one of my fields, it must meet certain filters, but in the end it must bring me the totalized in a unique way. For example, I have my data as image 1 and I need to have the total as image 2.
Thanks for your help!

(image1)

(image2)

[amitchandak]

You can create a new table like

summarize(filter(table, table[ILE00]="MIN"),table[BWART],table[AUFNR],table[ISM00],table[ILE00])

Appreciate your Kudos.

[DanCasSan]

Hi @amitchandak , thanks for your help, but the result throws me a table and I need to do the sum of a column of that summary table.