Sum on a group not including one of the rows of the detail in a grouping

I have my data set

column1  column2 column3 column4 column5

data1     data1    data1   data1  data1
data2     data2    data2   data2  data2
data3     data3    data3   data3  data3
data4     dat开发者_StackOverflowa4    data4   data4  data4

sum        sum      sum     sum    sum

I have those sums of those columns but I want to show the data 4 in the detail in the sum i dont want those numbers included. Any ideas?

---

set your expression to = sum(iif(data = data4, 0, data))