2 Replies Latest reply: Dec 17, 2012 7:17 AM by Marwim 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