4 Replies Latest reply: Jan 9, 2013 1:34 AM by 983694 RSS

    How to get data in this format

    Azamshareef
      I have two views namely
      without_meeting and with_meeting

      Iam getting this data from without_meeting view

      IP_DISTRICT TOTAL_APPLICATION P1 PE
      Anantapur 4 189 46
      Chittoor 5 500 121
      East Godavari 15 1964 275
      Kadapa 10 637 111
      Khammam 3 202 98
      Mahaboobnagar 1 40 30
      Medak 10 928 479
      Nellore 5 8269 518
      Prakasam 31 13353 2750
      Ranga Reddy 41 15044617 2160
      Srikakulam 3 122 36
      Visakhapatnam 51 84483 3159
      Vizianagaram 5 1039 67

      I am getting data from with_meeting view

      IP_DISTRICT TOTAL_APPLICATION P1 PE
      Chittoor 37 10866411979 1001230
      East Godavari 4 24589530 811166
      Guntur 6 1104747 330915
      Khammam 14 6282602854 677103
      Krishna 2 4809298000 33940
      Mahaboobnagar 3 561707 184973
      Srikakulam 8 363158 183276
      Visakhapatnam 63 12327008 2397861
      Vizianagaram 11 3607822 514191
      Warangal 7 1340630 378431

      i want to club this data like in this wat
      IP_DISTRICT TOTAL_APPLICATION P1 PE
      Anantapur 4 189 46
      Chittor 42 10866412479 1011351
      So On...........

      Please help me