Thread: pivot formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default pivot formula

I have a pivot table with revenues and expenses. The revenues has to
shown as a positive and the expenses are positive.I then want the
grand total to be the difference betweem the revenue and expenses. I
dont want to change the data just the pivot. Thanks.