Thread: Pivot table
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot table

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