Hello,
I need to create a graph with a cumulative percent.
Based on what I read here http://wiki.answers.com/Q/How_..._cumulative_percent, I can create a temporary file that gives me the individual values and the percent.
But how can I add the percent value of the step before?

Thanks in advanced,
Carlos Dias

This message has been edited. Last edited by: Carlos Dias,

You can not.
That would be mathematically incorrect.

But you can:

TABLE FILE CAR
	SUM SALES DCOST
	COMPUTE PERC/D12.2% = ( DCOST / SALES ) * 100;
	COMPUTE CUME_SALES/D12 = CUME_SALES + SALES; NOPRINT
	COMPUTE CUME_DCOST/D12 = CUME_DCOST + DCOST; NOPRINT
	COMPUTE CUME_PERC/D12.2% = ( CUME_DCOST / CUME_SALES ) * 100;
BY CAR
END

So first make a CUME_ of the two components you need in you percentage.
Then calculate the cumulative percentages.

G'luck.
Dave

you can

just ad an extra compute

CUMUL_PCT=LAST CUMU_PCT+ PCT;

The solution posted by Dave solve my problem.

Thanks,
Carlos Dias

Hi,

I found this great solution to my problem that Dave posted of running a cumulative column. However, the problem I have is that my report is BY Vendor So I will have several rows of records by Vendor and then the Vendor# changes and several more rows of records for that vendor, I need the Cumulative column to recalculate every time the The Vendor Number changes.

Vendor InvoiceAmt CumulativeAmt
ABC 100 100
ABC 200 300

XYZ 50 50
XYZ 200 250


I appreciate any help. Thanks.

Only logical for me to answer this :-)

TABLE FILE yourfile
SUM InvoiceAmt
    COMPUTE CumulativeAmt/D12 = IF LAST FST.Vendor EQ FST.Vendor THEN CumulativeAmt + InvoiceAmt ELSE InvoiceAmt;
BY Vender
END

You just have to make the Cumulative column smarter. It now checks wheter the Vendor of the LAST row of the internal matrix is the same as te one on the current row.
In your case you don't need the FST. because Vendor is alphanumeric. If Vendor is a number you will need to use FST. Because otherwise SUM Vendor will sum the Vendornumber and you won't be able to do the check.

G'luck,
Dave

Worked perfectly Thanks so much Dave!