I have a pivot table where the source looks like this:

|Company|Quarter|Year|Sales
IBM | 4 | 2005 | 5555
IBM | 4 | 2006 | 6219
APL | 4 | 2005 | 1234
APL | 4 | 2006 | 1800

I'm trying to build a pivot table that will return the quarterly
percent growth for each company, where % growth is defined as the
latest quarters sales over the like quarter a year ago growth. For
example, the pivot table might look like:

Quarter: 4
Company | % Growth
IBM | 12%
APL | 22%

I've been struggling with it.Most of the time, if I change the field
settings to % Difference from I get a bunch of #NA's.

Any suggestions?

Thanks,

Steve