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.