Hi All,
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
| | Q3 | Q4 |
| ID | | |
| 2 | 20 | 40 |
| 1 | 11 | 10 |
| Total | 31 | 50 |
Kindly help me
