| Question_ID | QuestionTarget | Target_MEN | Target_women | Target_Boy | Target_Girl | DistrictID | Quarter | year |
| 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 1 |
| 1 | 2 | 4 | 4 | 4 | 4 | 1 | 2 | 1 |
| 1 | 2 | 43 | 2 | 3 | 32 | 2 | 1 | 1 |
| 1 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 1 |
As above table I want to show a chart in crystal report showing the
TOTAL_TARGET which is sum of SUM(Question_Target+Target_Men+Target_women+Target_Boy+Target_Girl) as one column and i want to show the total of all district as in this table there are four rows for two districts I want to show the sum of these four columns for each district id in crystal report i am calculating the sum of these four formula using formula field but it show the total of all district accumative i want individual record for each district