Hello all.

I am able to get the revenue percentage for each given entry using PCT as follows:

COMPUTE MTDRevenue_PoT/D7.4% = PCT.MTDRevenue;

This works beautifully but is based on the grand total of the report. If, however, the report was subtotaling by month I would want to show this same percentage of revenue for each month. As such, is there a similar helpful "PCT" command to get this, such as SUBPCT or something to that effect?

Thanks all!

Edit: I found the following example that appears like it would work, but I receive a parsing error on "WITHIN":

COMPUTE MTDRevenue_PoG/D7.4% = PCT.MTDRevenue WITHIN RevenueMonth; AS 'Monthly Percent'

RevenueMonth is the primary "BY".

This message has been edited. Last edited by: Jeff-TTC,

Try this:

  
TABLE FILE CAR
SUM PCT.RCOST WITHIN COUNTRY NOPRINT
COMPUTE JEFF/D6.2%=C1;
BY COUNTRY SUBTOTAL
BY CAR
END

That worked!

Thanks much!

Jeff,
That it worked is a fact.
The question is: do you understand?