I am having set of ID fields which common for quarters but not always. Hence I need to calculate the values which is common. My data set look alike
QTR, ID, Value Q4,1,10 Q4,2,20 Q4,3,30 Q3,1,11 Q3,2,40 Q3,4,10 Here I need to sum only the IDs of 1,2 since these are the ids common between the Quarters. Hence my output should be like this
