I usually use the pivot table to to the lion share of the work, then copy it
to another sheet, do an edit copy, then edit pastespecial values to make it
not a pivot table. Then dress it up to get the final product. This is for
static reports. You implied that you don't want anything but the pivot
table, so I have no suggestions for that unless you can add columns to your
original data to give you what you want, but it didn't sound like it to me.
I will admit, that I have had little use or understanding of the Percentage
options in pivot tables.

Maybe you can find something useful at Debra Dalgleish's site.

Debra Dalgleish
http://www.contextures.com/tiptech.html

Look under P for Pivot Tables. She is releasing a book on Pivot Tables, so
you might find some useful information there.

--
Regards,
Tom Ogilvy



"Cam" wrote in message
oups.com...
Hello Tom,

Do you have any other suggestions for getting an "instant' Income
Statement out of a Pivot Table?


Regards,
Cam