13,552,932 members
See more:
Hi All,

I have column planvalue and actualvalue. coloum has repeated values for jobno i wanted sum at bottom of the column such that it takes

```jobno  planvalue    actualvalue
1        3000          2000
3000           500
3000           500
2        5000          3000
5000          2000
3        2000          1000
2000           500
2000           250
2000           250

(sum)             actualTotal```

no problem in actualTotal.
how can i get (sum) such that (3000+5000+2000)=10000

ie. single value from group jobno

sum(3000+2000+5000) that is unique values or Groupby jobno value single time
Any help is greatly appreciated.

Thank you and more power.
Posted 14-Mar-11 23:24pm
Updated 14-Mar-11 23:45pm
v2

## Solution 1

Gerry-Logrosa 16-Mar-11 0:18am

hi,
is there any samples using tables?
Sandeep-Mewara 16-Mar-11 5:26am

Top Experts
Last 24hrsThis month
 Maciej Los 260 Richard Deeming 190 OriginalGriff 189 ppolymorphe 145 RickZeeland 80
 OriginalGriff 5,219 ppolymorphe 2,372 Richard MacCutchan 2,185 Wendelius 1,890 Maciej Los 1,775