Thank you very much. I have one more question, if you have time…
This is the last code you suggested and it works, but I forgot to tell you that I have to add one more column:
(From d In nakonfilteradt.AsEnumerable() Group d By k=d(“TEKUĆE STANJE DUGA”).toString.Trim Into grp = Group Let coun = grp.count Let s = grp.Sum(Function(x) If((x(“TEKUĆE STANJE DUGA”).ToString.Trim.IsNumeric),CDbl(x(“TEKUĆE STANJE DUGA”).ToString.Trim),0)).ToString Let ra = New Object(){k,s,coun} Select r = newdt.Rows.Add(ra)).CopyToDataTable()
We used to use this file for grouping data
but now I have to add column “VRSTA KREDITA NA 4 NIVOU” to the original query (so grouping is needed by “TEKUĆE STANJE DUGA” and “VRSTA KREDITA NA 4 NIVOU” , and also I have to add that new column to query result).
Could you help me with this?