2 Replies Latest reply: May 15, 2014 9:53 AM by Chris.Unger _ RSS

    A little help please!!!!!

    Chris.Unger _

      I'm racking my brains out on this one.  Here is my setup data...

       

      Total for "ZIP Code" 62501 -


      > 219                                                                               

      Total for "ZIP Code" 62521 -


      > 47                                                                               

      Total for "ZIP Code" 62526 -


      > 33                                                                               

      Total for "ZIP Code" 62554 -


      > 304                                                                               

      Total for "Control Area" ARG -


      > 603                                                                               

      Total for "ZIP Code" 72513 -


      > 145                                                                               

      Total for "Control Area" ASH -


      > 145                                                                               

      Total for "ZIP Code" 62311 -


      > 71                                                                               

      Total for "Control Area" AUG -


      > 71                                                                               

      Total for "ZIP Code" 46105 -


      > 54                                                                               

      Total for "Control Area" BAI -


      > 54                                                                               

      Total for "ZIP Code" 62312 -


      > 247                                                                               

      Total for "Control Area" BAR -


      > 247                                                                               

      If you look, you can see that the zip code is listed first and the control area is the sum of it's grouped zip codes.  I need to be able to return this data in this format....

       

       

      Control_Area

      Zip_Code

      ARG

      62501

      ARG

      62521

      ARG

      62526

      ARG

      62554

      ASH

      72513

      AUG

      62311

      BAI

      46105

      BAR

      62312

                                      

      Since the control area is below the zip code in my report, I can't get my desired results.  I don't know if what I'm asking for makes sense to anybody, but if you can help, I would greatly appreciate it.