You can use a custom calculation to show the difference from one column
to another. There are instructions in Excel's Help, and he
http://www.contextures.com/xlPivot10.html
Nadeem wrote:
The pivot table gives the total of columns by default. But I need to see the
difference of one column over the other (in value or percentage), e.g. the
growth of sales in 2008 over 2007. Can I do it without having to copy the
data on a new sheet and doing it in Excel?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html