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%-----------373This message has been edited. Last edited by: Suzanne,
WF 766 Win2K
June 12, 2006, 07:08 PM
dwf
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