My new requirement is apart from the subtotals I need the counts for each subhead.The count should be printed under 'Win Probability'.I tried using a COMPUTE but it does not work.
Can somebody help me.
Thanks.This message has been edited. Last edited by: Kerry,
May 25, 2011, 03:22 PM
Don Garland
I'm not exactly sure about what you want to see as the final output. But I think you want to create a count for each level of sort? Here is my favorite method for doing that sort of thing.
quote:
TABLE FILE CAR SUM CNT.CAR AS 'NOFC' BY COUNTRY
SUM MODEL BY COUNTRY BY CAR END
Create your calculations at each level, you'll need to repeat the BY fields as you take the report down to the lowest level but the Metrics can be different for each BY level.
So taking a wild guess at your code, it might look something like this.
quote:
DEFINE FILE EMP_H BLANKFIELD/A8=' '; END
TABLE FILE EMP_H SUM CNT.WIN_PROBABILITY_FULL = 'Total,Win,Full,Name' BY 'FULL_NAME' NOPRINT
SUM CNT.WIN_PROBABILITY_JOB = 'Total,Win,By,Job' BY 'FULL_NAME' NOPRINT BY 'PCG_JOB_ROLE' NOPRINT
SUM BLANKFIELDNOPRINT BY 'FULL_NAME' NOPRINT BY 'PCG_JOB_ROLE' NOPRINT BY 'OWN_FLAG' NOPRINT
SUM CNT.WIN_PROBABILITY_UPNAM = 'Total,Win,By,Upper Name' BY 'FULL_NAME' NOPRINT BY 'PCG_JOB_ROLE' NOPRINT BY 'OWN_FLAG' NOPRINT BY UPPER_CNAME NOPRINT
SUM 'PROD_SUB_TYPE_VAL' AS 'Prod Family' COMPUTE CREATE_DT/MDYY = HDATE(CREATED, 'MDYY'); AS 'Create,Date' CNT.WIN_PROBABILITY_NAM = 'Total,Win,By,Name' BY 'FULL_NAME' NOPRINT BY 'PCG_JOB_ROLE' NOPRINT BY 'OWN_FLAG' NOPRINT BY UPPER_CNAME NOPRINT BY 'NAME' AS 'Client Name'
SUM COMPUTE CLOSEDT/MDYY = HDATE(CLOSE_DT, 'MDYY'); AS 'Est. to,Close Date' SALES_CYCLE WIN_PROBABILITY/D12% EST_VALUE/D20CM AS 'Est.,Value' EST_REVN/D20CM AS 'Est.,Recurring,Revenue' EST_1X_FEE/D20CM AS 'Est. One-,Time Fee'
BY 'FULL_NAME' NOPRINT BY 'PCG_JOB_ROLE' NOPRINT BY 'OWN_FLAG' NOPRINT BY UPPER_CNAME NOPRINT BY 'NAME' AS 'Client Name' BY 'OPTY_ID' NOPRINT
ON FULL_NAME SUBHEAD ""ON FULL_NAME SUBTOTAL 'EST_VALUE' 'EMP_H.EST_REVN' 'EST_1X_FEE' AS 'Total' ON OWN_FLAG SUBHEAD "ON OWN_FLAG SUBTOTAL 'EST_VALUE' 'EST_REVN''EST_1X_FEE' AS 'Sub-Total' END