Forum Discussion

DanCasSan's avatar
DanCasSan
Helper V
6 years ago

Distinctive calculation

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)

 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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's avatar
      DanCasSan
      Helper V
      6 years ago

      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.