Results 1 to 3 of 3

Difference between colums in pivot

Threaded View

IM2HARD2RESIST Difference between colums in... 10-14-2009, 02:24 PM
NBVC Re: Difference between colums... 10-14-2009, 02:58 PM
IM2HARD2RESIST Re: Difference between colums... 10-15-2009, 11:25 AM
  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    Pune, India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Difference between colums in pivot

    Hello, I have an excel sheet with a pivot table with some data about the trades that I have done in the stock market. Before reading the query request you to please have a look at the attachment as I have referred a few data columns.

    Coming to the pivot table, in column 'I', I have the 'Total Sum of Trade Value' column which basically adds up the data frome columns E and G (i.e. Sum of trade values under 'Buy' and 'Sell'). I also have the brokerages paid for buying as well as selling and the brokerages are summed up in column J. Basically, what I want to do is to be able to get a difference between different columns within a pivot table. So I want a column which will have 'G-E-J' (Sum of Sell value - Sum of Buy value - Sum of Brokerage). I could click on one of the data fields and after selecting Value filed settings, it shows the summarized by tab. However here, I could only see functions like, Sum, Count ..etc ..but Difference isn't there PLease help !!!!
    Attached Files Attached Files
    Last edited by IM2HARD2RESIST; 10-15-2009 at 11:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1