SUM of a column based on value of another column

Stranger12

I have 10 column into datatable table . In which I want do sum for column 8 based on the value of column 3. I want to exclude value of column 8 from SUM where value for the same row in column 3 is "waiting response" and I want SUM of distinct value of column3.

My table is looks like in image
!

or you can check image here: https://pasteboard.co/H0iCJqA.png

allan

Use columns.render to perform calculations in a cell based on the values of other cells in the row. See also the manual on renderers.

Allan