Danish Habib

Danish Habib

  • NA
  • 694
  • 245.7k

I want to show sum of four columns as Total in crystal Repor

Sep 3 2015 6:14 AM
 Question_ID QuestionTarget       Target_MEN Target_womenTarget_Boy Target_Girl DistrictID  Quarteryear 
 1 1 2 2 2 2 1 1
1 2 4 4 4 4 1 2 1
 1 2 43 2 3 322 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