no, you need to add a calculated field to do so. Rajan
On Wed, 7 Jun 2017 at 10:40 AM, B Sharma <sharma....@gmail.com> wrote: > Dear Friends, > I have a database in which the transactions (both buy & sales) of shares > trading has been entered. > > I have another sheet in which I need results using Pivot table. > > But it calculates the sum of both buy & sales, but I need the subtract of > Buy with sales and show the balance results. > > There is an option "Difference of" but it not showing proper results. > > *I Can alternatively put minus signs in all the sales transactions but > that is not possible for a big database.* > > Any easy alternative solution will be highly appreciable. > > Thanks in advance. > B. Sharma > > -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
