The PPROPERTIES subcommand gives you control over the formatting, so you could show another decimal place, or show another decimal in the numbers to which the PCOMPUTE is being applied. You can't use the regular transformation system functions to solve this.<br>

Other than that, you could use a small custom function with the SPSSINC MODIFY TABLES extension command to replace the Diff column with one computed more to your liking. The custom function would have to be in Python, but it would only need a few lines of code. I can help with that if you want to go this route.

HTH,
Jon Peck

 Thanks Jon!<br>

I tried the PPROPERTIES. Ultimately, these are being converted to percentages, so adding the decimal places doesn't help in this specific scenario.

If you could help me with the MODIFY TABLES, that would be great. I've worked with it a little, but only to the extent of pivoting outputs, and some conditional formatting.

CK

 If you can provide an spv file with the table you want to convert and the exact expression you want to replace the PCOMPUTE total, I'll take a look.<br>

I am working on a general extension command that can do computations over any cells in a table in a more general way than PCOMPUTE, but that probably won't be ready for a few weeks.

Regards,
Jon

 Thanks Jon!<br>

I'm having a hard time attaching a file to this message. I have created a sample .spv, along with an Excel file to show what ultimately I'm trying to achieve. Is there an FTP site I can drop this to, or email?

CK

 Just email it to me at<br>
  peck AT us.ibm.com
  
             

 Sorry I haven't gotten back to this sooner. I have been working on a general extension command that can do computations over the cells of a pivot table. I have posted a beta version of this command, which is called STATS TABLE CALC. You can get it from the Extension Commands collection on the SPSS Community site.<br>

I tested this on your sample table, and it did what I think you want. The package includes a dialog box interface, but here is the syntax I used on your table.

STATS TABLE CALC SUBTYPE=
"custom table" PROCESS=PRECEDING /TARGET FORMULA=
"round(x0,2) - round(x[-1],2)" DIMENSION=COLUMNS LEVEL = -2  LOCATION=
"Diff" LABEL=
"Diff" MODE=REPLACE.

You can read about it in the dialog help or by running the command with /HELP, but the key point is the formula. This formula takes the first column and the last column before the Diff column, rounds each value to two decimals and subtracts. The result replaces the existing Diff values.

Try this out and see how it holds up. Remember that it is a beta test version. Pivot table structures are very complicated!

HTH,
Jon Peck

 Now I apologize for the delay, other project work has taken me away from this task.<br>

That appears to have done the trick! Thank you so much for your help!