Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot formula officegirl Excel Discussion (Misc queries) 1 December 6th 07 11:22 PM
Pivot Formula Paul Dennis Excel Discussion (Misc queries) 1 November 13th 07 01:09 PM
cancelling getpivot formula when setting formula outside pivot ta. cancelling getpivot formula Excel Worksheet Functions 2 October 31st 06 10:31 PM
deactivate the get pivot formula when I link a cell to a pivot hwtradezheng New Users to Excel 1 January 4th 06 01:47 PM
Add a formula to Pivot Table bsfacf Excel Worksheet Functions 0 January 21st 05 05:40 AM


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"