Let me explain my requirement:
I have an infopath form in my Marks_Sheets form library. It has two fields which
captures marks for Mathematics & Science. Let's think two users fill up the
form. When we merge these two forms i am able to pull the data from 2 records
and show like below.
---------------------------------------
1)Mathematics 80
Science 65
2)Mathematics 60
Science 45
---------------------------------------
My Query is, can i summarize these fields like sum of all mathematics, and sum
of all Science
and data should be display like below
---------------------------------------
Mathematics 140
Science 110
---------------------------------------