AnsweredAssumed Answered

report totals

Question asked by HB on Nov 14, 2012
Latest reply on Nov 15, 2012 by philmodjunk

Title

report totals

Post

     I tried to figure this out for hoursbut no solution - please help!

      

     I have a "cust" database table with fields:

     "Custnum" contains cust id

     "sex" text contains "male" or "female" or blank

     "age" text contains 4 groups of age brackets one of "-25" or "26-50" or "51+" (from a value list) or blank

     "Total sales" numeric contains custs tot sales to date etc

     (FYI - the range etc may change in the future - I would modify the value list & update the existing data in the cust table & hopefully not need to change report layout on each change)

     I want one report to show:

      

     Sex                  Count    %                 Spent   %

     _____________________________________

     Male                   40   40%                $480      48%

     Female              60   60%                $520      52%

      

     Age                    Count    %                 Spent   %

     _____________________________________

     -25                     10   10%                $300      30%

     26-50                20   20%                $400      40%

     50+                    70   70%                $300      30%

      

     Totals                   Count                  Spent 
                                    100                     $1000

      

     Thanks in advance

Outcomes