I need to display a total count by district/by area and display the percentage for each area (% of grand total). I also need to calculate the YTD total count using a different date range than is used to get the monthly count.

Can you have where statements for each verb in a multiverb statement? (If so, I can't seem to get it to work.)

Any suggestions for the best way to accomplish the following:

---------------Count---Pecentage-----YTD Count
District A
------Area A------10------19.23%-----------123
------Area B------12------23.08%------------12
------Area C-------5--------9.61%------------34
_______________________________________________
--------------------27------51.92%-----------149

District B
------Area A------3--------5.77%------------56
------Area B------0--------0.00%------------78
------Area C-----22------42.31%------------90
______________________________________________
-------------------25-------48.08%-----------224
______________________________________________
______________________________________________
Grand Total-----52-------100.00%-----------373

This message has been edited. Last edited by: Suzanne,

I don't have a good way to test this right now, but I wonder if something like this might work:

DEFINE FILE WHATEVER
COUNTMO/I7C = IF DATE FROM fromdate TO todate THEN 1 ELSE 0;
COUNTALL/I7C = 1;
END

TABLE FILE WHATEVER
SUM
COUNTMO AS 'Count'
PCT.COUNTMO AS 'Percentage'
COUNTALL AS 'YTD Count'
BY DISTRICT
BY AREA
ON TABLE RECOMPUTE
END

Thanks!