View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Pivot Table Calculation

Hi

Is it possible for Pivot Tables to calculate differences between 2 columns.
For instance I have a a table showing a range of dates down the x-axis (row).
I have limited the column axis to only 2 values. I have removed "Show grand
totals for rows" as this adds the 2 values together. I actually want to see
the difference between the 2 values rather than their sum?
--
Kevin